You need to sign in to do that
Don't have an account?
Stefano Amenta
Business hours for weekdays and weekends
Hi,
Recently I have been using this formula to calculate business hours for 5 days a week, for 9 hours, from 9am to 6pm China time.
The problem is that now the team will also start to work on Saturday and Sunday, but on a slightly different time: from 10am to 9pm China (11 hours).
How could I incorporate the new time inside the below formula? So the formula should consider two different timeframes: 9am to 6pm (weekdays) and 10am to 9pm (Saturday and Sunday).
How could I achieve that?
Recently I have been using this formula to calculate business hours for 5 days a week, for 9 hours, from 9am to 6pm China time.
The problem is that now the team will also start to work on Saturday and Sunday, but on a slightly different time: from 10am to 9pm China (11 hours).
How could I incorporate the new time inside the below formula? So the formula should consider two different timeframes: 9am to 6pm (weekdays) and 10am to 9pm (Saturday and Sunday).
How could I achieve that?
9 * ( ( 5 * FLOOR( ( DATEVALUE(Now()) - DATE( 1900, 1, 8) ) / 7) + MIN(5, MOD( DATEVALUE(Now()) - DATE( 1900, 1, 8), 7) + MIN( 1, 24 / 8 * ( MOD(Now() - DATETIMEVALUE( '1900-01-08 01:00:00' ), 1 ) ) ) ) ) - ( 5 * FLOOR( ( DATEVALUE([Case].New_status_time_track_ALL__c) - DATE( 1900, 1, 8) ) / 7) + MIN( 5, MOD( DATEVALUE([Case].New_status_time_track_ALL__c) - DATE( 1996, 1, 1), 7 ) + MIN( 1, 24 / 8 * ( MOD([Case].New_status_time_track_ALL__c - DATETIMEVALUE( '1900-01-08 01:00:00' ), 1) ) ) ) ) )