=SUM(A1:A5)*24 for totalling hours and minutes is not working

C

Calebs Grandma

I am trying to total up hours worked in a one week time period. I found the
noted formula if the total is going to be >24 hours. However, I cannot get
an accurate total. Any thoughts comments, would be greatly appreciated.
 
P

Peo Sjoblom

Either use

=SUM(A1:A50)

and format as [hh]:mm under format>cells>number>custom

or format as general and use

=SUM(A1:A50)*24
 
G

Gary''s Student

Remember that your formula return hours. This means that if the formula gives:

1.25 ===> this really means one hour 15 minutes.
_________________________
Gary's Student
 
Top