How to add time values?

R

Resultcompany

Hi,

I would like to generate the totals of a mobile phone invoice were eac
call is in the hh:mm:ss format.

If possible I would like to know if exel is able to add every call so
can verify the total time called to a destination by adding the colu
and have as result the total of hh:mm:ss called in that colum.

Hope to hear from you.

Marty

Attachment filename: time.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56243
 
N

Norman Harker

Hi Martyn!

Just add times as you would other numbers but format the result with
custom format [hh]:mm:ss
 
B

Bob Umlas, Excel MVP

Add as normal: =SUM(A1:A5), for example. If the result is over 24 hours, format as [h]:mm:ss
 
Top