cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Calculate difference in time accounting for business hours

Hi,

 

In Excel I used a formula which determined the time difference between 2 datetimes and returned based on a calendar the number of hours for resolution based on business hours. e.g. 8AM to 8PM is the business hours range and it's from Monday to Friday. If the ticket was raised at 9PM on a Thursday it would only start the counter from 8AM on Friday.

 

Wondering how to do this in PowerBI?

1 ACCEPTED SOLUTION
Microsoft
Microsoft

@timwilson

 

I think your requirement should be almost same as this thread. You should only need to change the business end time. Please try to following the steps listed to see if it works.

 

Best Regards,

Herbert

View solution in original post

2 REPLIES 2
Microsoft
Microsoft

@timwilson

 

I think your requirement should be almost same as this thread. You should only need to change the business end time. Please try to following the steps listed to see if it works.

 

Best Regards,

Herbert

View solution in original post

@v-haibl-msft

 

Thank you, it worked perfectly.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors