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
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!