total worked hours for a week

[Steven]

I'm trying to sum up the worked hours for a week on my
worksheet. Problem is the total number of hour can not
be viewed after the formula keyed in. The formula reads
as follows: =sum(a1:a9)*24, and the format of the cell
has been changed to 'General'. Text function is used in
cells from a1 to a9. Could this be the reason causing
the problem of not being able to see the total?

Thanks.

 

[Earl Kiosterud]

Stephen,

The SUM function won't add text cells. Why are they text. What do they
look like. Give examples.

 

[Lester]

in cells a1:a5, enter monday-friday, formatted as text.
in cells b1:b5, format cells as number, with 2 decimal
places. enter number of hrs for each day.
format cell b6 as number with 2 decimal places and enter
=sum(b1:b5).

I don't understand why you're multiplying the total number
of hours by 24.