Time Sheets

[Helen Black]

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

[Alex Delamain]

Can you give some sample data showing formats etc as this might help?

[JulieD]

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" <Helen.Black.1lzthn@news.officefrustration.com> wrote in
message news:Helen.Black.1lzthn@news.officefrustration.com...
>
> 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