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
Bookmarks