Hello
I have a file that creates a work rotation schedule, based on the rotation, hours worked per day, and start and end dates, and the file/formula works great, however it assumes the same amount of hours worked per day. I need to add in the capabilities to change the hours worked per day, specifically the travel in (day before the rotation starts, and the day after the rotation finishes).
Please see attached file, the top table is the current table I use formulas in the dates range, I would like to adjust this formula to include the travel days/hours in and out as per the bottom table example.
Any help would be greatly appreciated
Thanks
I have a file that creates a work rotation schedule, based on the rotation, hours worked per day, and start and end dates, and the file/formula works great, however it assumes the same amount of hours worked per day. I need to add in the capabilities to change the hours worked per day, specifically the travel in (day before the rotation starts, and the day after the rotation finishes).
Please see attached file, the top table is the current table I use formulas in the dates range, I would like to adjust this formula to include the travel days/hours in and out as per the bottom table example.
Any help would be greatly appreciated
Thanks