Calculate hours between two times per day and add them up, result at the end of the week.

This is for employee time sheet and schedule. I have multiple employees work a specific shift on various days. I need the calculate the hours worked each day and then have them totaled at the end of the period. Here is and example:

Employee Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total Hours Total Cost
John Smith 10-5 12-6 9-2 5-10:30 3-8:30


So the questions are: How do I get it to calculate the difference in the same cell, convert it to hours, add up all the results and place it in the totals columns then calculate those totals by their pay rate to get my Labor cost? Any help would be much appreciated.

Thanks,

dgw