#### chrisderby123

##### New Member

- Joined
- Jan 16, 2017

- Messages
- 3

I've read over a few different forums and haven't found the solution that has worked properly for me, so I'm hoping something can help me with this.

I have an employee schedule that I need to be able to count the total amount of hours for each shift. If I can get a formula that works for a daily basis, then I can just make a SUM formula for the weeks totals myself. It's a restaurant, so a lot of the shifts start in the evening and end in the morning on the next day. Example: Monday 6:00PM - Tuesday 2:00AM.

This is a link to a screenshot of my spreadsheet with some random number inputs.

This is the custom format of the numbers that I have for the number inputs: 0\:00 p;0\:00 \a

So my managers just need to input 500 for 5:00 p and -300 for 3:00 a

The day of the week and dates all change when I change the date in cell D1.

Each row is a different employee.

Really just need a formula/format that will:

1. Track total hours for each shift, for each row.

2. Fast and Simple number format for the managers to input daily shift times.

Example: If a shift is from 6:30PM to 2:00AM, I need a value of 7.5.

Example: If a shift is from 10:00AM to 4:00PM, I need a value of 6.

Please let me know if you need any other information for clarification.

Thank you!

Chris