Dear Team,

My company has working timing of Monday to Friday 10:00 to 19:00 and on Saturday 10:00 to 15:00.

I want a formula which helps me in defining the working hours (as mentioned above Monday to Saturday)and also exclude non working hours(which is Mon to fri 19:00 to 10:00 and for Sat 15:00 to Mon 10:00), Sunday and Holiday list (if any).

Any help would be appreciated a lot.

Thanks,
Manish_Gupta