| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get total amount of hours in time format
05:20
07:20 07:30 07:30 07:00 05:20 05:45 the above numbers are all individual times eg ( 5 hours and 20 minutes). I need to add them all, which should come up to 45 hours and 5 minutes. The format is [h]:mm for more than 24 hours, but the toatl it shows is 93:45 .. Can anyone show me which formula to use to add up time. I have tried all other from different websites(mrexcel.com etc) and have tried all of ther suggestions, but still am stumped |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add 10,0015:15 hours to 03:53 Hours to a total time | Excel Worksheet Functions | |||
| Calculate total time(hours/minutes) from text/custom format column | Excel Discussion (Misc queries) | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) | |||
Threaded Mode
