Do you know what the formula would be for calculating completion date and time? I have the Start date and time and the number of hours to complete. And I would need to skip 5am, 6am, and 12noon.
The production hours are from 7am-4am the next day.
If possible I need one formula to include weekends and one to exclude weekends?
I tried to attach the file but it would not work.
Thank you,
Shenna
The production hours are from 7am-4am the next day.
If possible I need one formula to include weekends and one to exclude weekends?
I tried to attach the file but it would not work.
Thank you,
Shenna