Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi fine Forum people,
How to calculate (total) delivery time between two dates/times, excluding weekends and holidays except if (express) delivered on Saturday.........in hours (elapsed time).
Excel Networkdays formula only gives full complete days and doesn't format in hours.
"Duration" Power Query doesn't exclude, and Networkdays M-Codes also result in full days.
Below PQ screenshot of the challenge to slaughter your brain cells :).
Thanks in advance.
Greetz
Im not sure but i hope the below link will be any usefull 👍
HI Sasidhar,
Thank you for you prompt reaction.
Love your solution but it is not what I was looking for.
At first glance your solution is a 9-5 working hour solution. I need a "24 hours" solution to measure performance of the delivery teams.
I will try to modify your formula by stripping down the working hours and or wrap a IF statement for the Saturday express deliveries.
Though!
Thank you very much for your effort an attention.
GreetZ
HansZ