How can I get the column to accurately track hours elapsed?

Hello!

Trying to have Total Time calculate total hours elapsed from Start Time to End Time. I created "helper" columns based on another question's answer, but it didn't help. We use 24-hour clock here and I need the column formula to consider that some values will start before midnight and end after midnight and will calculate the time accordingly.

Any thoughts?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!