calculate minutes a delivery is late

Melanie Sanders
Melanie Sanders ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am wanting to create a formula whereas I have an expected delivery time and actual delivery time and need to determine how many minutes the delivery was late. Does anyone know what formula to use in Smartsheet?


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Smartsheet currently is unable to calculate time. However, depending on your setup and overall requirements, some basic formulas in helper columns can be used.


    Will the expected and actual times overlap into another day? Do you want it displayed in just minutes? What format are you using for time (12 or 24 hour clock/colon or no colon/am vs pm/etc..)? Are you able to post some screenshots with dummy data manually entered to show what you want the final solution to display?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!