#1   Report Post  
Neville
 
Posts: n/a
Default Time calculations

How can I add two or more sets of hours:minutes:seconds? For example, if I
add 12hr30min00sec to 1hr45min45sec I should get 14hr15min45sec.
  #2   Report Post  
Alan
 
Posts: n/a
Default

Try formatting the cell which contains the addition formula as
[hh]:mm:ss
Regards,
Alan.
"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.



  #3   Report Post  
Myrna Larson
 
Posts: n/a
Default

YOu can add the values if the cells contain the time values 12:30:00 and
1:45:45, but not if they contain the exact text (with hr, min, and sec
embedded) that you show in your message.

On Mon, 19 Sep 2005 11:21:05 -0700, "Neville"
wrote:

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

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


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