Time Sheets
 

When I am doing the formula =SUM(H7:H15)*24 on my time sheet and setting
the total to numbers so that it gives me the correct totals the formula
is making my sheet go out I think it is rounding the totals up with
having to multiply by 24 to get the sheet working right.

Can any one help me get this right as I cannot have my sheet rounding
up by as much as 13 minutes on some times.

Helen


--
Helen Black

Hi Helen

can you type out an example of when it's rounding as i've not noticed this
when i've used this method

cheers
JulieD

"Helen Black" wrote in
message ...

When I am doing the formula =SUM(H7:H15)*24 on my time sheet and setting
the total to numbers so that it gives me the correct totals the formula
is making my sheet go out I think it is rounding the totals up with
having to multiply by 24 to get the sheet working right.

Can any one help me get this right as I cannot have my sheet rounding
up by as much as 13 minutes on some times.

Helen


--
Helen Black