Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to add up time duration values, given to me, in the following
format hh:mm. The hours (h) value always resets to 0 when it reaches 12:00. I need to calculate the total number of hours used. For example: 5:37 Five hours and thirty seven minutes. 13.58 Thirteen hours and fifty eight minutes. 25:14 Twenty five hours and fourteen minutes. ----------------------------------------------------------------- 44:49 Forty four hours and forty nine minutes. How can I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding a code to calculate how much time is lost | Excel Discussion (Misc queries) | |||
Adding time HH:MM when it addds up to more than 24 hours | New Users to Excel | |||
Adding time | Excel Worksheet Functions | |||
what is the formula for adding up time intervals? | Excel Discussion (Misc queries) | |||
adding in time formats | Excel Discussion (Misc queries) |