1

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=c8ad7111f9da4fb3a160d2cbf25d…

Functionality

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.