Hi
I really hope someone can assist.
The attached workbook is a team roster. Tab 'Apr 23' is what the staff see, however payroll want it in the tab 'month template v2' version.
I am hoping there is some formula we can use that will duplicate their rostered hours. I have used PM and Monday 3rd as an example.
You will note however that in tab 'Apr 23' under SHIFT 5, the times are already there, so i don't know if a separate formula will be required to duplicate those hours. I have used BG2 on Wed 5th as an example for this one.
Please help me Roster.xlsx
Thanks so much
Bookmarks