Time and rounding

[Linda]

I need to be able to not round in a time sheet.
Exp: week one total time is 40 and 1.45 ot
Sencond week is 40 and .38 OT
When you add the two OT you get 1.83, but using a format to add you get 1.84.
I need it to say 1.83 how do i change how it rounds?

 

[Biff]

You should round the values 1.45 and 0.38 first if they're the results of
formulas.

A1 = 1.45498
A2 = 0.38459

=SUM(A1:A2) = 1.83957 = 1.84

Or, if you only have a few numbers to add:

=SUM(ROUND(A1,2),ROUND(A2,2)) = 1.83

Biff

 

[Sloth]

Tools->Options->Calculation->Precision as Displayed
Checking this box will make Excel work the way you want. BE CAREFUL using
this. This method will permanently remove any digits beyond what is
displayed, unless they are the results of formulas.

 

[Bob Phillips]

Or do it in one if you have lots with this array formula

=SUM(ROUND(A1:A2,2))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)