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 " , "")
yesbet88
July 3, 2022Beast