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.
