Hi all

My payroll officer has pointed out to me that the time sheet i have
created is good but i am loosing out on cash because the way they work
out the hours is different to the way my time sheet dose, on my time
sheet if i work for 7 H and 40 Mins it
Displays as 7:40. But here is where i lose out as when the payroll see
7:40 they take it as 7H 24Mins. Dose anyone have a suggestion as to how
i can get 7:40 to display the correct time (7:67) with out starting from
scratch?


the payroll work on the following setup
1min= .02
10mins= .17
15mins= .25
20mins= .33
30mins= .50
40mins= .67
etc.

these are my current formulas

cacluates lunch period
=E10-D10
total time worked less total lunch
=((F10-C10)-G10)
total OT for the day
=J10-I10
Total Time Worked + OT =SUM(H10:H23)+K24 (K24 is the cell containing
the total of the over time)

this time sheet covers a F/N

Thanks in advance
Regards,
Jesse


--
Jesse_Norris
------------------------------------------------------------------------
Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546
View this thread: http://www.excelforum.com/showthread...hreadid=401382