Lakshpraks
New member
- Joined
- Dec 31, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi,
i have a shift schedule for a week and i need the following data from it:
1. I want to know the count (staffing) in time intervals.
For ex:
Monday:
01AM to 11PM - 2 Agents (count)
11PM to 6AM - 1Agents
etc till logout...
The data is here:
i have a shift schedule for a week and i need the following data from it:
1. I want to know the count (staffing) in time intervals.
For ex:
Monday:
01AM to 11PM - 2 Agents (count)
11PM to 6AM - 1Agents
etc till logout...
The data is here:
Monday | Tuesday | Wednesday | |||||
31st dec | 1st Jan | 2nd Jan | |||||
Emp ID | Name | Login | Logout | Login2 | Logout2 | Login3 | Logout3 |
123456 | John | 12:00:00 AM | 10:00:00 AM | 12:00:00 AM | 10:00:00 AM | 12:00:00 AM | 10:00:00 AM |
78910 | Paul | OFF | OFF | OFF | OFF | 1:00:00 AM | 11:00:00 AM |
890123 | Peter | 1:00:00 AM | 11:00:00 AM | 3:00:00 AM | 12:00:00 PM | 6:00:00 AM | 10:00:00 PM |
987654 | Adam | 3:00:00 AM | 12:00:00 PM | 6:00:00 AM | 10:00:00 PM | 1:00:00 AM | 11:00:00 AM |
321654 | Micheal | 6:00:00 AM | 10:00:00 PM | 7:00:00 AM | 11:00:00 PM | 1:00:00 AM | 11:00:00 AM |