Working Hours between two datetimes M-F (Including Saturdays)

[rogerthat]

I'm trying to figure out to how to implement working hours from two different datetimes.

• M-F (8A-5P)
• SATURDAY (8A-4P)

Must disregard Holidays

I've tried using this method from Bill Szysz but I'm having a hard time incorporating the Saturday hours.

[Greg_Deckler]

@rogerthat Can you use a DAX solution? Net Work Duration (Working Hours) - Microsoft Power BI Community

[rogerthat]

@Greg_Deckler Would the the solution also account for holidays? So if its a holiday, SLA hours should not be counted?

[Greg_Deckler]

@rogerthat You could have a holidy table and in the __NetWorkDays VAR formula you could do an EXCEPT around the CALENDAR statement to exclude the holidays. Also, in that same statement you would want <7 instead of <6 in order to include Saturdays.

[rogerthat]

@Greg_Deckler I'm not sure the calculation is correct for me

For example, for 

start	end	expected	result
9/17/2021 19:58	9/17/2021 21:50	0	112