Time and rounding

L

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?
 
B

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
 
S

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.
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top