Adminstrator · Salesforce

Salesforce Formula to Calculate Elapsed 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 " 
, "")

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s