adding time in columns

[BAKERSMAN]

I am trying to add time(Hrs and Minutes) in columns. I have time in hrs and
minutes and I want to see the total time of the entire column. Do I need to
format this a special way for it to work?

 

[Peo Sjoblom]

Use custom format [h]:mm to display time greater than 24 hours, or multiply
the result with 24 and format as general or number


--


Regards,


Peo Sjoblom

 

[Mike H]

Hi,

Sum the times as if they were numbers

=Sum(a1:a20)

and apply a custom format of [HH]:mm

Mike