Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Need a way to calculate hours and minutes
We are using the hours and minutes duration option for our projects and need a way to calculate the stop time based on the duration. We enter the duration and Start Time and want Smartsheet to calculate the stop time (currently we have to enter it manually and there is definitely margin for error... not to mention time consuming):
Any advice on how to get the stop time calculation would be greatly appreciated!
Comments
-
The question has come up before, the discussion below may help. There are also other threads about this...
-
Thanks for the feedback Brett... I had already read through the discussion in the link you sent over and they all address calculating hours based on start and end times.
But what I need to do is enter the start time and duration and have the stop time automatically calculated. I've found no discussions that address how to accomplish this. Any other ideas?
-
Hi Bobbie,
Any chance you have figured this out yet? We need the same exact same functionality for cutover tasks and have been trying/testing lots of things without success.
-
Hi Kyla,
I'm afraid this is a pretty manual process for us. We add a formula for Start Time so that it picks up the stop time from the previous row. If Row 1 has a Start and Stop time, then the formula for Row 2's Start time would be:
=[Stop Time]2
This at least gives us the start time for the next task. I've researched and have found no way to auto generate stop times based on start time and duration.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives