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.