Results 1 to 4 of 4

Text Time to Excel Format, Then Sort Time Past Midnight

Threaded View

BuntyMac Text Time to Excel Format,... 07-27-2014, 12:13 AM
cbatrody Re: Text Time to Excel... 07-27-2014, 01:38 AM
SnarlingSheep Re: Text Time to Excel... 07-27-2014, 01:57 AM
BuntyMac Re: Text Time to Excel... 07-27-2014, 03:13 AM
  1. #1
    Registered User
    Join Date
    02-21-2011
    Location
    Australia
    MS-Off Ver
    MS Office 2016 on Windows 10
    Posts
    42

    Text Time to Excel Format, Then Sort Time Past Midnight

    I need some advice please:

    I am supplied with a schedule (generated from a server) which lists times in the following format as an example:

    Given Text Time
    2330
    5
    40
    115
    150
    220
    2310
    2340

    Not very neat & tidy! I have a formula that works for every time, except for the hour past midnight. =--(LEFT(C2,LEN(C2)-2)&":"&RIGHT(C2,2)) (thanks to this forum)

    Times such as '5' and '40' result in a #Value! error.

    I also need to sort the times past midnight as in.... 23:30 would come before 00:05

    Any help would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Time calculation not working past midnight
    By Sophie.Durrant in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2014, 08:18 PM
  2. [SOLVED] Calculating time that goes past Midnight
    By jonvanwyk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2013, 04:14 PM
  3. Replies: 4
    Last Post: 01-11-2012, 07:59 PM
  4. Calculate time which is past midnight
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-25-2011, 12:11 PM
  5. [SOLVED] Calculating Time Past Midnight
    By Darren in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2006, 11:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1