EileenJohn
Board Regular
- Joined
- Nov 23, 2016
- Messages
- 53
Hi, I have daily data and calendar.
In daily data it keep date, staffid, time, type time,etc. In calendar, it have staff shift schedule.
Eg: Daily Data (21 dec)
16630 Shift A 8am exit
16630 Shift A 7.53pm in
16630 Shift A 11.04pm exit
Daily Data (22 dec)
16630 Shift A 00.23am in
Eg: calendar
Date group timeIN. timeout
21/12. A. 20.00. 8.15
22/12. A. 20.00. 8.15
N. 7.45. 17.15
C. 8.00. 20.15
So , how to calculate total staff? During day time it should display group working on daytime. Then when night time, it should include all group ( day and night). Anyone have any idea? Thanks in advance
In daily data it keep date, staffid, time, type time,etc. In calendar, it have staff shift schedule.
Eg: Daily Data (21 dec)
16630 Shift A 8am exit
16630 Shift A 7.53pm in
16630 Shift A 11.04pm exit
Daily Data (22 dec)
16630 Shift A 00.23am in
Eg: calendar
Date group timeIN. timeout
21/12. A. 20.00. 8.15
22/12. A. 20.00. 8.15
N. 7.45. 17.15
C. 8.00. 20.15
So , how to calculate total staff? During day time it should display group working on daytime. Then when night time, it should include all group ( day and night). Anyone have any idea? Thanks in advance