Delivery time between two dates in hours excluding non-working days except express delivery!!.

[HansZ]

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

[Sasidhar01]

Im not sure but i hope the below link will be any usefull 👍

https://www.extendoffice.com/documents/excel/3825-excel-calculate-net-work-hours-between-two-dates-e...

[HansZ]

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