Subtracting time using formulas

Shawn Roberts

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? 

J. Craig Williams

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

 

Travis

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! 

Shawn Roberts

Thank you Craig and Travis for your responses. 

Craig, when do you anticipate the improvement to the formula engine to be completed? 

J. Craig Williams

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

 

JohnHinkle

I would love to see this! 

Travis

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