Help with Time being rounded off on timesheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Biff (biffinpitt_at_comcast.net)
Date: 09/28/04 

Date: Mon, 27 Sep 2004 17:20:38 -0700

Hi!

When I set the cell format to number with 15 decimal
places *AND* goto Tools>Options>Calculation>Precision As
Displayed, the value returned is:

6.799999999999990

You can use the TRUNC() function to get the value returned
of 6.79, that's as good as it'll get!

So, if this person makes $10/hr, you just "saved" the
company $.10 or, just helped create a disgruntled employee!

Also consider the possible implications of setting
precision as displayed! You may "solve" one problem but
create others.

Biff

>-----Original Message-----
>Hi,
>
>I have created a time*** with the help from the Pearson
Excel Site, and it
>works great with the formulas he has provided, but the
final hours keep
>rounding off. If someone could please help!
>
>Here are my formulas:
>
>Time IN Lunch Out Lunch In End Time
>7:01 AM 1:03 PM 1:54 PM 2:40 PM : with the
formula in the total hrs Column
>worked =(F2-C2+(F4<C4))*24, which gives me the total of
7.65, however, the
>Column Worked Hrs should be 6.78 but it is rounding it to
6.80. Can someone
>help to keep the Column Worked Hrs from Rounding???
>
>Thanks
>
>
>
>.
>

Quantcast