Calculation of the duration in working hours

[Anonymous]

Hello,

I have two columns in DD / MM / YYYY HH: MM: SS format for which I want to calculate the duration in hours worked.
The working day is between 8 a.m. and 6 p.m. It will therefore be necessary to exclude the period from 6 p.m. to 8 a.m.

Thank you

[amitchandak]

@Anonymous , There is blog on that, please check if that can help

https://exceleratorbi.com.au/calculating-business-hours-using-dax/