Hi,

Sum the times as if they were numbers

=Sum(a1:a20)

and apply a custom format of [HH]:mm

Mike

"BAKERSMAN" wrote:

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?