P
Peter Rooney
Good morning, all!
We've finally accepted that people don't actually work 7.5 hours a day on
projects! However, this leaves me with a plan that needs peoples' working
days reducing to 5.5 hours, which should extend the end dates of their
projects.
So, what I want to do is, for each calendar, (each team member has their own
named calendar, not simply the one that is created automatically for them)
change the length of the working day to 5.5 hours by making the end of the
day (shown as nonstandard working hours) 2 hours earlier.
How can I do this easily, (VBA would seem to be the answer) since if I
highlight MTWTF headers and change the end of the working day, this will
change all days marked as holidays, to the new hours too, adding days back in
that were previously marked as nonworking.
Thanks in advance
Pete
We've finally accepted that people don't actually work 7.5 hours a day on
projects! However, this leaves me with a plan that needs peoples' working
days reducing to 5.5 hours, which should extend the end dates of their
projects.
So, what I want to do is, for each calendar, (each team member has their own
named calendar, not simply the one that is created automatically for them)
change the length of the working day to 5.5 hours by making the end of the
day (shown as nonstandard working hours) 2 hours earlier.
How can I do this easily, (VBA would seem to be the answer) since if I
highlight MTWTF headers and change the end of the working day, this will
change all days marked as holidays, to the new hours too, adding days back in
that were previously marked as nonworking.
Thanks in advance
Pete