Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Time Difference Calculation Using Military Time

I am struggling coming up with a time difference calculation smartsheet.

I have two text fields, one called From and the other To. Users are to input time in a military format (exp: 07:00, 13:00) and then the calculation should fill my Duration field with the difference between those two times.

Can this be done without date columns? Seems simple enough but I have no luck as of yet.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions