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!