Labour Cost per Hour Based on Shifts

I am struggling to develop a timetable worksheet. I so far have a dropdown list of employees associated with their hourly wage, fields to enter their shift start and end time, and the total shift duration. I also have a larger chart that tracks earnings per hour and want to expand that chart to include labour cost per hour.

Is there a way that I can have Excel calculate how much an employee worked per hour (9am, 10am, 11am, etc) based on their shift start and end time? Once I have this function it is an easy matter to add this function together for each employee to return total labour cost per hour.

EDIT: Added test file.