chrisderby123
New Member
- Joined
- Jan 16, 2017
- Messages
- 3
Hey Team!
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
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