A working formula to calculate End Date and Time based on Start Date and Time and allocated hours.
Mindfull
✭✭✭✭✭
Can any one help on getting a formula to calculate End Date and Time based on Start Date and Time and Allocated hours for a Project considering 8 am to 8 pm working hours and excluding Saturday, Sunday and Holidays?
Answers
-
I recently helped someone with a very similar solution. Feel free to browse through the links in THIS THREAD to see if any of them will work for you, and I will dig through my notes to see if I can find the more specific details.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!