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
Check out the Formula Handbook template!