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
