Calculating Time Duration of Outage

Kristin Gregory
edited 01/04/24 in Formulas and Functions

I am having trouble calculating the Time duration of an outage. I have attempted to use a formula found to calculate time worked which is ultimately the same but I cannot get it to work. I am not sure what I am doing wrong. Outage Start Date and Outage End Date are Date Columns and the others are all Text/Number Columns

This is the formula I am using that was posted on the Communities site


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!