Time and rounding
 

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?

Time and rounding
 

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

"Linda" wrote in message
...
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?

Time and rounding
 

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.

"Linda" wrote:

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?

Time and rounding
 

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)

"Biff" wrote in message
...
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

"Linda" wrote in message
...
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?