Time and rounding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Linda - 22 Nov 2006 21:07 GMT

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?

Reply to this Message

Biff - 22 Nov 2006 22:35 GMT

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

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

Reply to this Message

Bob Phillips - 23 Nov 2006 09:46 GMT

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)

> You should round the values 1.45 and 0.38 first if they're the results of
> formulas.
[quoted text clipped - 16 lines]
> > 1.84.
> > I need it to say 1.83 how do i change how it rounds?

Reply to this Message

Sloth - 22 Nov 2006 22:39 GMT

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.

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

Reply to this Message