Lead Age (1)


Salesforce Formula For Calculating Case Age In Hours Excluding Weekends

This is a modification of the Salesforce formula for finding the number of business hours between two dates. Here is the Salesforce formula: ROUND( 8 * ( ( 5 * FLOOR( ( DATEVALUE( date/time_1 ) – DATE( 1900, 1, 8) ) / 7) + MIN(5, MOD( DATEVALUE( date/time_1 ) – DATE( 1900, 1, 8), 7) […]