Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

bikelley's avatar
bikelley
Helper IV
5 years ago

Anonymous and Anonymous 

Hello, 

 

Can you please share the correct formula? (Or working PBX file will be great) 

 

 I am trying to do the same thing and I tried a few other things that I found online. Did not work. Can you please share the formula? I can not download the PBX file. It gives me an error. 

 

Thank you so much