=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.

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

--

Regards,

Peo Sjoblom

"Calebs Grandma" <Calebs Grandma@discussions.microsoft.com> wrote in message
news:2C8710A2-ED9C-4566-9954-FCAB38ABACDC@microsoft.com...
> 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.

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.