| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time difference function
I'm having problems finding the difference between to columns of time
formatted into mm:ss. The difference shows up as ##### So, I converted each column of mm:ss into numbers with this formula: =TIMEVALUE(TEXT(I3,"hh:mm")) such that 03:00 = 0.002083333, 02:04 = 0.086111111 the difference = 0.088194444 using format custom mm:ss to reconvert back to time is 07:00. Now I'm stuck just not sure which function I should use to correctly reconvert the difference back into "mm:ss" Any help is greatly appreciated. Thanks EVan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between times. Start time: 11:30PM End time: 5 AM | Excel Worksheet Functions | |||
| Time formula (difference of predicted and actual time) | Excel Discussion (Misc queries) | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
Threaded Mode
