| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time diffrence with 24 hour clock
can you tell me the formula for telling the time diffrence between 2 times
when the either time may appear after midnight, without the need for a 48hr clock time due - 23:00 time arrived - 01:00 (2 hours) time due - 01:00 time arrived - 23:00 (blank) but using a 24 hr clock this shows as 22 ours late when in fact is 2 hours early thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round time to the nearest quarter of an hour | New Users to Excel | |||
| rounding up time to quarter hour increments | Excel Worksheet Functions | |||
| Cells with time format and calculating the diffrence | New Users to Excel | |||
| Production CLock | Excel Worksheet Functions | |||
| how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions | |||
Threaded Mode
