Formula for calculation time differences by business hours


@Paul Newcome

I am looking to calculated the time difference in business hours which are 8am to 5pm and also exclude holidays

Below is an example of the data and there are no breaks. this is time worked on a service call.

Thank you :)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!