Convert Excel fx to a Power Query fx

[RattlingCarp3048]

in my table i have 2 date/time columns and need to calculate the difference between them in hours. I manually entered this formula into a newly added custom column directly in the table. however, i would like the power query to do the calculation instead. how do i convert this excel function into something the power query custom column will accept?

=IF(OR([@ACS]="",[@GPU]=""),"NO SCAN",(NETWORKDAYS([@ACS],[@GPU],Table3[Holidays])-1-MOD([@ACS],1)+MOD([@GPU],1))*24)

expected outcome

ACS	GPU	ACS to GPU (Hours)
5/23/2024 10:18​	5/24/2024 13:46​	27.48​

 

[RattlingCarp3048]

***site will not let me edit original post**

I found that adding a new custom column with a simple (startdate - enddate)*24 then change the data type to decimal and round will calculate to hours like i need which is much easier than i thought (yay!!).... problem that still remains is how do i exclude weekends and holidays??

**with 5/27/24 as a holiday**