Trying to calculate date and time.

I am looking to calculate date and time to match up to a performance metric.

Example: A work order is called in on 02/01/21 at 08:00 and its a priority 1 call which requires a tech to be on site within 24hours M-F excluding Federal holidays. So i am looking to measure date & time from the moment the work order is called in until the tech arrives on site. Then i can take the total hours and measure it to the performance metric.

Any assistance will be helpful, thanks.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!