View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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?