Forum Discussion
Calculating working hours between 2 dates disregarding weekends and holidays
Hello, community. How can I create a calculated column that gives me the working hours between two "date/time" columns, disregarding weekends and holidays, considering business hours from 8am to ...
Hi Anonymous ，
I rewrite the formula for calculating the working time between 2 dates, you can get the formula from PBIX file shared in OneDrive.
Best Regards
Rena
To get networking days , Refer
https://community.powerbi.com/t5/Desktop/NETWORKDAYS-type-function-in-PowerBI/td-p/154902.
On the day it start take diff from end time and date it end take diff from start time. And date diff from Start +1 and end -1.