Overtime Tracking

[squirrellydw]

Can someone help me make a Overtime Tracking Sheet? I would like it to list the Name of the Employee, the Hours they worked that DAY, the current TOTAL hours they have worked for the Month, Quarter and Year, and the Last DATE they worked. I would also like to be able to figure out who hasn't worked in the longest time. For example you have 50 employees and two have never worked any OT based on the DATE, they should be next to work.

Any idea how I can set this up and make it easy for others to use? Ideally I would just like to input HOURS and DATES.

Thanks

 

[Logit]

.
http://www.calculatehours.com/excel-how-to/calculate-overtime.html

https://www.extendoffice.com/documents/excel/4281-excel-calculate-overtime.html

https://www.template.net/business/sheet-templates/overtime-sheet-template/