Can time be automated by hours in a Smartsheet column?

Smartadmin2

Hello, for a few days I have been trying to automate time, not by days (because in smartsheet automations time is automated in days when recording a date) but in hours, so that through automation or a formula, a time can be recorded when a cell is modified, and at the same time those hours can be operated on, adding or subtracting hours, I would like to know if that is possible? If there is a formula or method to be able to record hours in columns and at the same time perform operations with them.

Melissa Yamada

@Smartadmin2 you can try checking this community thread that might help you on the solution you need utilizing the Modified Date system column.

https://community.smartsheet.com/discussion/110784/is-there-a-way-to-timestamp-using-a-formula