Archived 2015 Posts
Archived 2015 Posts
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.
Subtracting time using formulas
Is there a way in Smartsheet, like in Excel, that you can subtract time? I have a "Completion Time" column, and a "Start Time" column, and I am wanting to get a duration of the time between. I want to evaluate the amount of time it takes to complete a task.
AAny suggestions?
Comments
-
Shawn,
=[Completion Time]-[Start Time]
See this link for more Date related functionality:
http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas#date
Hope this helps,
Craig
-
Craigs suggestion will work in some cases but not if you are trying to calculate actual time, such as 10:30am - 5:50pm.
We are working on improvements to our formula engine will include the ability to calculate time. Stay tuned for this and other great enhancements!
-
Thank you Craig and Travis for your responses.
Craig, when do you anticipate the improvement to the formula engine to be completed? -
Shawn,
Travis is the one to ask.
I eagerly await each new improvement like a child on his birthday. But I have to wait like everyone else.
I take a look at the road map every once in a while.
https://www.smartsheet.com/product-roadmap
Craig
-
I would love to see this!
-
Shawn, we dont have a set timeframe for when the new engine will be released. We are currently working on it and there is a lot of testing that needs to go into it as it will touch a lot of functionality in the app. Keep checking out product roadmap as that will give you a good idea of what is coming soon
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I have looked through all of the answers for this topic, and still cannot find a solution that works for me. I have a sheet with a multi-select dropdown used to code responses. In another sheet, I wan…
- I have 1 sheet that has duplicated Classroom IDs but different scores on each line. I need to flag any instances during the same term of a difference over 1.00 higher or lower with the same Classroom …
- I have two formulas that are fairly identical but one is producing a #NO MATCH error. =COUNTIFS(Shop:Shop,Shop@row,[Review Start Date]:[Review Start Date], YEAR(@cell)= YEAR([Review Start Date]@row)) …