help required with a table that will help me work out the over time for where i work..

i need in the table the following

ie
Monday

name - leigh
start time - 8.00
finish time - 6.00
standard hours - 8
ot hours - 2

tuesday

name - leigh
start time - 8.00
finish time - 6.00
standard hours - 8
ot hours - 2

wednesday

name - leigh
start time - absent
finish time -
standard hours - 0
ot hours - 0

thursday

name - leigh
start time - 8.00
finish time - 6.00
standard hours - 8
ot hours - 2

friday

name - leigh
start time - 8.00
finish time - 6.00
standard hours - 8
ot hours - 2

then i will have a colum at the end that adds the total overtime hours for that person.. but i then were absent or on holiday for any day overtime for that week would be lost until they hit there 38 hrs then overtime would start again... please help as i have used the help function on excel but nothing thanks...

you can email me leighmetcalfe@hotmail.co.uk

If you use the formula where A1=Name, A2 Start time, A3 =Finish time, then enter the times using 24 hour clock, For Monday it would be B2 = 8, B3 = 18 (6 o'clock evening) then use "=SUM(B3-B2)-8" will give you the OT Hours. Use Sigma to add up the OT hours in the row.
B1=Mon, C1=Tue etc etc. I'll send it by mail.

Sent you spreadsheet. Hope this is what you were asking for