Is there a formula to calculate the time elapsed between two automatic time stamps?
I'm thinking something like Updated  Created = Elapsed, but I don't yet speak Smartsheet formulae fluently.
Thank you,
Miguel
Answers

Smartsheet doesn't currently have formulas specific to time like this, or a timestamp function yet. You could find the elapsed time in days, but not in hours.
To find the difference in days, you would just do exactly what you noted above:
=Updated@row  Created@row
This will give you a numerical value of the difference, in days, with decimals representing the difference in time. For example, if the Modified Date is 12 hours later than the Created date, you'd have 0.5 as the result. If the Modified Date is 24 hours later than the Created date, you will return 1.
Our Help Center has more information about System Columns (see here) and using Dates in Formulas (see here).
Cheers!
Genevieve

I use the formula below to calculate elapsed minutes between the Created and Modified columns (i.e. the only 2 system columns where Smartsheet displays time).
(Modified@row  Created@row)*1440
I suspect the "Record a date" automation has a time associated with it in the database (i.e. every modern db captures everything to the second, if not millisecond), but the application doesn't currently display it. It would be a welcome enhancement.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!