Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Formula to Calculate hours worked minus lunch break

Nov 14, 2014 12:14AM PST

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.

Discussion is locked