Forum Discussion

HansZ's avatar
HansZ
Regular Visitor
3 years ago

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

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).  Exc...
Need Help
  • HansZ's avatar
    HansZ
    Regular Visitor
    3 years ago

    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