Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
time sheet calculations | Excel Worksheet Functions | |||
Time Calculations | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
Time calculations & text conversions | Excel Discussion (Misc queries) | |||
Time Sheet calculations | Excel Worksheet Functions |