![]() |
Adding up time durations?
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? |
Adding up time durations?
Format as:
[hh]:mm (not hh:mm) "Eric" wrote: 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? |
All times are GMT +1. The time now is 08:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com