View Single Post
  #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.