Help with time duration calculations
Zack
✭✭
Hi Paul, I've found a couple of your threads where you've helped people out with functions to calculate duration between time stamps listed in an HH:MM format on a 24 hour format. I've tried using some of the existing functions you put through in other threads but haven't been able to get them to work. I've attached a screenshot but essentially my team will enter a conversion start time and conversion end time and we need the duration between the start and end for the column "conversion total time". We then input a ramp up end time and need the difference between the ramp up end time and the conversion end time to get the "ramp up total time". Any help would be greatly appreciated!
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!