| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formats
Hello,
Using Excel 2003, I am trying to convert 24 hour times (currently formatted as general) into h:mm AM/PM. My ultimate goal is calculate the difference between times, which sometimes straddles two 24 hour periods. See example data and current formatting below. Hope someone can help. Thanks, -- Carla Arrival time Departure time Difference 2335 0250 1340 0200 1400 0240 1355 0130 1300 0220 1435 0245 0730 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time formats | Excel Worksheet Functions | |||
| Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
| Help with time formats | Excel Worksheet Functions | |||
| Time Formats | Excel Discussion (Misc queries) | |||
| Time Formats | Excel Discussion (Misc queries) | |||
Threaded Mode
