Duration between Military Time

What is the easiest formula to use to determine the time difference between two Military Times? I'm using the 4 digit military time and also I need the formula to calculate across midnight. I'd like the time difference to be in minutes (but that can be done in a separate column formula). I know @Paul Newcome has skills when it comes to calculating time.

Example: End time = 1450, Start time = 1225

Example: End time = 0041, Start time = 2125

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!