time analysis via modified columns for automated alerts
I'm trying to find a pattern as to how the numbers are generated when two modified by cells are subtracted from each other. At first I thought it was in minutes and separated via location in the number, but upon testing that proved to be incorrect.
Does anyone know how to translate the number that is given when two modified by columns are subtracted from a decimal to something useable?
https://app.smartsheet.com/b/publish?EQBCT=c8ad7111f9da4fb3a160d2cbf25d33eb
Comments
-
Hello,
Looks like your sheet has been unpublished.
Subtracting two "Modified by" date columns provides you with a duration in days in the form of a decimal value.
NOTE: The time component is ignored in this calculation, only the difference between the date values is taken.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!