How to get date and time via formula in the smartsheet?

Santhosh

Paul Newcome

Are you able to provide more context?

Santhosh

Yes, for example in the Smartsheet if we give TODAY Function we get only the date "09/09/2022", similarly, I am expecting a formula where I can show the date and time in the same cell. Else, is there a function where I can calculate only the total hours between two dates?

Paul Newcome

The only ways to capture a time are to manually enter it or have it automatically output in either a system generated Created (date) type column or a system generated Modified (date) type column.

From there you can use some of the solutions found in the below thread to calculate the amount of time in between.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time