formula - Time
Options
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?
Comments
-
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
-
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!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
