LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding a code to calculate how much time is lost vwghia21 Excel Discussion (Misc queries) 3 September 6th 06 08:54 AM
Adding time HH:MM when it addds up to more than 24 hours Smudge New Users to Excel 8 August 30th 06 03:41 AM
Adding time Ken Davie Excel Worksheet Functions 10 June 5th 06 06:54 PM
what is the formula for adding up time intervals? thinkrabbit Excel Discussion (Misc queries) 4 May 24th 06 06:57 AM
adding in time formats rvnwdr Excel Discussion (Misc queries) 1 May 31st 05 11:38 PM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"