Help with Time being rounded off on timesheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have created a timesheet 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
 
Sorry I forgot to provide the formula now being used in the Column (Hours
Worked) that keeps rounding to the higher number. Sorry. the formula is as
follows

=((F2-C2+(F2<C2))-(E2-D2+(E2<D2)))*24

Thanks
 
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 timesheet 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
Click to expand...
formula in the total hrs Column
 
The cells are set as follows:

Time In = format of Time 7:01 am
Lunch Out = format of Time 1:03 pm
Lunch In = format of Time 1:54 pm
End Time = format of Time 2:40 pm
Total Hours = format of General with 2 decimals
Worked Hours = format of General with 2 decimals

I hope that I have them set correctly, I am greatful for your help.

Thanks,
 
Back
Top