Calculate the difference between dates & Times

Options
StephaneJvR
StephaneJvR ✭
in Formulas and Functions

Hi,

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?

· Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!