ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding up time durations? (https://www.excelbanter.com/excel-discussion-misc-queries/119524-adding-up-time-durations.html)

Eric

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?


Teethless mama

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