adding time in columns

  • Thread starter Thread starter BAKERSMAN
  • Start date Start date
B

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?
 
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
 
Hi,

Sum the times as if they were numbers

=Sum(a1:a20)

and apply a custom format of [HH]:mm

Mike
 
Back
Top