| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating time difference in minutes
jonhunt wrote: Scoops, I had already tried the other suggestion of 1440 and that doesn't seem to work. Hi Jon Both David's and daddylonglegs solutions work fine for me, though I did amend them to =24*60*-(B6-C6) and =(B6-C6)*-1440 to change the +/- Is your data ok? Regards Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time calculations | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
| Adding minutes to time | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
