ShowAll Questionssorted byDate Posted
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?

```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) ) )
)
)
)```