Calculate the work hours between 2 dates( datetime) excluding weekends - 9 am - 6pm Mon-Fri

[Melissa]

Hi @Sim2312,

Please check out this forum topic, it refers to a Power Query function to calculate the time between two dates excluding Non working hours, weekends, holidays in either hours or minutes.

Time format 37:30:55 greater than 24 hours

. Okay so Bill Szysz created a Power Query M function that does just that and here it is: (WHStart, WHEnd, Start, End, ListOfHolidays) => let DStart = Number.From(DateTime.Date(Start)), // start day TStart = Number.From(DateTime.Time(Start)), // start time DEnd = Number.From(DateTime.Date(End)), // end day TEnd = Number.From(DateTime.Time(End)), // end time // List of days without saturdays and sundays ListOfNumbe…