Pull hours from one sheet to another based on date

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

Thank you for your response.


This doesn't exactly do what I need. The problem I am having is when there are multiple shifts or jobs in one day, I need it to add those hours together.

I have attached the highlights.


Thank you



ot_tracker(1).xlsx

Perfect, Thank you!