Hi,

I have an over time tracker that I created to monitor scheduled hours vs actual hours worked leading to 40.

I was looking to have the tracker ("OT_Tracker" sheet) pull the hours from the schedule sheet ("emp_schedule" sheet) to populate the schd. hours columns.

I need it to populate for each day along with adding hours together when there are multiple job codes in one day as in employee d.

Any help would be greatly appreciated.

I have attached the file for reference.

Thank you

ot_tracker.xlsx