Calculate business working hours

[Claudiu_Anghelescu]

Hi,

I want to calculate the working hours between StartDateTime and EndDateTime.

There are multiple posts on community but only for 1 location, e.g. 09:00 -> 18:00. 

Which approach I have to apply if I have different locations with different working hours? 
E.g:

Paris:        09:00 -> 18:00

London : 08:00 -> 16:00 

Roma:      07:00 -> 15:00

And excluding holidays that can be different for each location. 

@Kushal_Chawda  

@rwunderlich 
@marcus_sommer 

@IAMDV 

[marcus_sommer · Accepted solution]

The logic itself didn't change if you have a single location or multiple ones with different properties. You need just to repeat your basic-data for the holidays / working hours and merge them together - personally I would simply concatenate them and adding the location to the key-field.

- Marcus

[Claudiu_Anghelescu]

How to proceed if I have vStartHour=5, vEndHour=2 ?