Calculate the difference between dates & Times


We use smartsheets to log support queries. I want to calculate the turnaround time between two dates:

Date the ticket was loaded and date that the ticket was closed

Date format: mm/dd/yy x:xx PM or AM

Is there a way to calculate the turnaround time?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!