Formula for difference in time
We run events and are putting together the tech runsheet which has a column for:
 Time Start
 Time Finish
 Timer
The timer column is what a speaker sees on their foldback monitor for how long they have left to present. I need this column to show the "difference" between Time Start and Time finish. (ie in the first row it will now 0.30 and in the second row it will show 0.02.
Can anyone assist with a formula pls? Simply subtracting doesn't work.
Thanks, Janette
Tags:
Answers

You should be able to find something in this thread. It may take a little digging because I think we are up to 10 pages, but there should be something there...

Can anyone assist to see if this formula is correct for pulling minutes? For some reason I'm getting some odd hours, or a negative.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!