Subtracting date and time

Tshack ✭✭
edited 12/09/19 in Formulas and Functions

I am working on a delivery smartsheet, where I need to figure out how long it takes to get a product from the order phase, to the parts picked to the delivered phase.

Here is a screenshot of how our times are formatted, these can be over multiple days and not just a single 24 hour period. I looked through other posts to see if there were similar issues that had been answered, I did not see any, was curious if there was any formulas out there that I could modify to fit my data.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!