total worked hours for a week

  • Thread starter Thread starter Steven
  • Start date Start date
S

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.
 
Stephen,

The SUM function won't add text cells. Why are they text. What do they
look like. Give examples.
 
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.
 
Hi,
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?
Click to expand...

Yes.
Either you change your values to numbers (please specify your function used in
A1:A9 so we can help in that area) OR use the following ARRAY formula (needs to
be entered with Ctrl-Shift-Enter) :


=SUM(A1:A9+0)*24

Regards,

Daniel M.
 
Back
Top