mitchande21
New Member
- Joined
- Jun 18, 2018
- Messages
- 2
I am having trouble finding an efficient way to manage this. What I am looking to do is find a way to calculate the total number of hours worked by employees for each hour during the day. There is an example of how the schedule exports to excel in a table below.
I want to find out how many hours are being worked from 7:00 to 8:00, 8:00 to 9:00, etc. By calculating manually, Employee 1 works for 1 hour during the 7:00 hour and employee 2 works for 15 minutes during the 7:00 hour so the total number of hours worked for the 7:00 hour is 1.25. Total hours worked for the 8 o'clock hour is 1.75. etc. How could I make excel calculate this for each hour throughout the day while taking into account when employees are off as well (ex. Employee 2 only works for 15 minutes during the 1:00 hour)
Thanks for any help here!
<tbody>
</tbody>
I want to find out how many hours are being worked from 7:00 to 8:00, 8:00 to 9:00, etc. By calculating manually, Employee 1 works for 1 hour during the 7:00 hour and employee 2 works for 15 minutes during the 7:00 hour so the total number of hours worked for the 7:00 hour is 1.25. Total hours worked for the 8 o'clock hour is 1.75. etc. How could I make excel calculate this for each hour throughout the day while taking into account when employees are off as well (ex. Employee 2 only works for 15 minutes during the 1:00 hour)
Thanks for any help here!
Employee | Time In | Time Out | Shift Length |
Employee 1 | 7:00 AM | 12:00 PM | 5 |
Employee 2 | 7:45 AM | 1:15 PM | 5.5 |
Employee 3 | 8:30 AM | 2:00 PM | 5.5 |
Employee 4 | 10:00 AM | 2:00 PM | 4 |
Employee 5 | 10:00 AM | 3:00 PM | 5 |
Employee 6 | 12:00 PM | 4:15 PM | 4.25 |
Employee 7 | 12:15 PM | 6:00 PM | 5.75 |
Employee 8 | 1:00 PM | 7:00 PM | 6 |
Employee 9 | 3:00 PM | 8:00 PM | 5 |
<tbody>
</tbody>