#1   Report Post  
Chip Pearson
 
Posts: n/a
Default

If the times are stored as normal Excel times, they just numbers
(representing a fraction of a 24 hour day, 0.25 = 6:00, 0.5 =
12:00, 0.75 = 18:00, etc), so you can simply add them as you
would with regular numbers, using '+' or SUM. Format the result
cell with a custom number format of [hh]:mm or [hh]:mm:ss .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Neville" wrote in message
...
How can I add two or more sets of hours:minutes:seconds? For
example, if I
add 12hr30min00sec to 1hr45min45sec I should get
14hr15min45sec.



Reply
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
time sheet calculations emmcee Excel Worksheet Functions 7 August 20th 05 12:26 PM
Time Calculations Paul T Excel Worksheet Functions 1 April 23rd 05 04:02 AM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM
Time calculations & text conversions Kenny Hubbard Excel Discussion (Misc queries) 1 February 5th 05 10:15 PM
Time Sheet calculations dkostel Excel Worksheet Functions 2 November 23rd 04 10:11 PM


All times are GMT +1. The time now is 03:55 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"