| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hour function equivelent help
If I want to find out how many minutes there are for times that I have
summed, I know I can use the hour function if the compiled time is less than 24 hours. But, what if I want to get the times that are over a 24 hour period, how do I do that? Example: 20:57:46 14:39:10 8:57:24 12:12:12 ------------- 56:46:32 <-- the minutes I'd like to get |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round result of sum function to quarter hour | Excel Discussion (Misc queries) | |||
| Convertig Number to Text - equivelent to single quote | Excel Worksheet Functions | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| About nesting the hour function | Excel Worksheet Functions | |||
| Hour() function | Excel Worksheet Functions | |||
Threaded Mode
