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

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.

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

Either use

=SUM(A1:A50)

and format as [hh]:mm under formatcellsnumbercustom

or format as general and use

=SUM(A1:A50)*24

--

Regards,

Peo Sjoblom

"Calebs Grandma" <Calebs wrote in message
...
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.

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

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


"Calebs Grandma" wrote:

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.