I am trying to make a monthly time sheet.


This is the layout

A B C D E
F G

Date Time Worked Lunch Total Reg O/T
Start End Enter Time Hours Hours Hours
24-Oct-06 6:30 AM 3:00 PM 0.5 8.0 8.0 0.0
25-Oct-06 6:30 AM 4:15 PM 9.8 8.0 1.8
26-Oct-06 6:30 AM 5:45 PM 0.5 10.8 8.0 2.8
27-Oct-06 6:30 AM 3:45 PM 0.5 8.8 8.0 0.8


Columns D, E, F, G and there totals are formatted to number with one decimal
point.

At the end of the month it automatically adds up the different columns.

If you enter 6:30 AM €“ 4:15 PM, in column E it rounds it from 9.75 to 9.8
hours which is what I want it to do. The problem is at the end when you tally
up all the hours in the different columns by using the auto sum button it is
not adding up what it sees in column E, it is adding up the exact times from
columns B and C.

eg. Even though it says 9.8 hours in column E, it is adding 9.75

The formula that I have used for Column E is

=IF(B6="stat",8,(C6-B6)*24)-D6

Column F

=MIN(E6,8)

Column G

=IF(E68,E6-8,0)

Can someone please help