Time Between Workdays in Calculated Column in Power Query

[DinoMania]

Hello.

I'm having a hard time with the power query language.

I need help making my calculated column to show time between two dates but only using workdays.

I currently only have the two date/time columns being subtracted.

= Table.AddColumn(#"Renamed Columns1", "Overall Approval Time", each [APPROVED]-[SUBMITTED])

Let me know if you need any additional information.

 

[billszysz]

Hi Dino
Look at my comment on this blog (there is an example file also)
Calculate Hours Worked in Excel with Power QueryThe Ken Puls (Excelguru) Blog