Calculate Business Hour TAT including half day saturdays

[atari35]

Hi, Im new on power bi and i need help with calculating a queries TAT. If one works between 8am and 5pm weekdays and 8am till 12pm on a saturday excluding sundays. Is there a way i can calculate the TAT of a query excluding as well the time when one is is not working?

Query Number                       Received_Time                    CompletionDate                     Status Turn       Around Time

12                                           21-06-2019 14:00                24-06-2019 10:00                Completed             9 hours

The above example shows a query that was logged on friday at 2pm. This means it should only calculate 3 hours for that day, then start counting on the saturday at 8am till 12 (add 4 hours) and continue counting on the monday till 10 am (2 hours).

[Greg_Deckler]

Perhaps look at using something like GENERATE. 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

[atari35]

Hi Greg,

Thank you for your reply. The generate function, does it also work with time? The examples you gave me are for date ranges and im looking to calculate by time