formula - Time

Laura

I have a sheet with an auto Created date & time column AND a modified date & time column.

 

Is there a way to create a formula column that will show Modified Date Time (minus) Create Date Time?

Paul Newcome

There is, but... It is horribly painful. Calculating time is something Smartsheet is not currently capable of, but there are a few workarounds. Check out the thread linked below.

 

https://community.smartsheet.com/discussion/calculate-time-between-two-dates-days-hours-and-minutes

Savanna K

Paul - I see you're extremely savy when it comes to Smartsheet, especially with calculating time.

I have a sheet with an auto Created date & time column and I want to calculate the hours from the created time to "now". Is that possible?

THANKS!