Latest Updates

Travel to Technology

Dayton Metro Library

Salesforce Formula to Calculate Elapsed Time b/w 2 dates

Salesforce Elapsed Function/Formula to Calculate Time B/w 2 Dates

Salesforce Elapsed Function/Formula to Calculate Time B/w 2 Dates

IF (Now() - LastModifiedDate > 0, 
TEXT(FLOOR(Now() - LastModifiedDate)) & " days " & 
TEXT( FLOOR( 24 * (Now() - LastModifiedDate - FLOOR(Now() - LastModifiedDate) ))) & " hours" & 
TEXT( ROUND(60 * (ROUND( 24 * (Now() - LastModifiedDate - FLOOR(Now() - LastModifiedDate) ),8) - FLOOR( 
ROUND( 24 * (Now() - LastModifiedDate - FLOOR(Now() - LastModifiedDate) ),8)) ),0)) & " min " 
, "")