adding time in columns
 

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?

adding time in columns
 

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


"BAKERSMAN" wrote in message
...
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?

adding time in columns
 

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?