Jan 17, 2017
2:16:51pm
2:16:51pm
Excel wizards: Do you think it's possible to get a short view monthly calendar
of employee schedule to autofill into a more specific daily calendar or vice versa?
So, right now I have a monthly calendar that has the shifts in each day.
Eg: 6a-6p George
6a-6p Sally
6p-6a Gerry
6p-6a Susan
Then a daily sheet that shows each hour broken down
6a George Sally
7a George Sally
8a George Sally
9a George Sally
10a George Sally
11a George Sally
12p George Sally
So, right now I have a monthly calendar that has the shifts in each day.
Eg: 6a-6p George
6a-6p Sally
6p-6a Gerry
6p-6a Susan
Then a daily sheet that shows each hour broken down
6a George Sally
7a George Sally
8a George Sally
9a George Sally
10a George Sally
11a George Sally
12p George Sally
- Bio page
- fattycoug
- Joined
- Sep 9, 2002
- Last login
- Apr 24, 2024
- Total posts
- 69,461 (11,072 FO)
Messages
Time
