Date Start Time Lunch Out Lunch In End Time Sick Vacation Holiday Total Hours Worked Comp Time Earned Comp. Time Taken
22-Nov-14 Off * * * 0
23-Nov-14 Closed * * * 0
24-Nov-14 8:30 12:00 12:30 5:00 8
25-Nov-14 8:30 12:00 12:30 5:00 8
26-Nov-14 8:30 12:00 12:30 5:00 8
27-Nov-14 Holiday * * * 8
28-Nov-14 Holiday * * * 8
Total 0 0 0 40 0 0
This is what my time sheets look like I can not seen to find a formula to calculate hours worked I have tried several please help.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic