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.

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.

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.

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.