time analysis via modified columns for automated alerts

L_123 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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?





  • Shaine Greenwood


    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!