| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Difference Between Two Times in General Format
I am using a google document survey to have users enter times in a military
format. The result is pasted into excel as a "General" format number, like 2253 to represent 10:53PM. They do not enter the semicolon between hours and minutes. I need to see the number of minutes between two times, such as 2257 - 2253 or 4 minutes. How can I convert general numbers, some of which are 04 to represent 00:04 AM, to serial times or time format? Thanks very much in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate flying times using 24hour clock and 0000 general format | Excel Worksheet Functions | |||
| How calculate difference between [t]:mm-format and general format | Excel Worksheet Functions | |||
| Calculating difference between times on 2 dates | Excel Worksheet Functions | |||
| Calculating the difference between 2 dates and times | Excel Discussion (Misc queries) | |||
| Calculating difference between two times | Excel Worksheet Functions | |||
Threaded Mode
