Change number of hours per day before it proceeds to the next

Yao Ming
Yao Ming ✭✭
edited 09/01/22 in Formulas and Functions

Hi all,

I'm currently running a project that my resource only work 3 hours a day on. Can anybody advise if it is possible to setup something that dictates number of working hours per day before the date goes to the next day?

eg. If i assign a resource 6 hours of work on a Project A (considering the resource only work 3 hours a day on Project A), the "Duration" column will automatically indicate 2 day and the start to end date will change accordingly.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!