Forum Discussion

EmptyCarSpot's avatar
EmptyCarSpot
Frequent Visitor
5 years ago

Subtract non-working hours

Hello, my question is how to subtract the hours during non-working hours, here is an example:


I am subtracting the hours between the shipping date and the current date but the first result was entered at 01:00 and the other at 09:00, how can I make the hours be subtracted when it is out of schedule?

ps: business hours are between 09:00 to 18:00

Need Help
Show and Tell
Tutorial Requests

1 Reply

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hello, EmptyCarSpot 

     

    I don't understand your thoughts very well. Are 19 and 12 the result you want? They seem to conflict with your logic? Or what the correct result should be?

    Can you explain your logic completely? So we can help you soon.

     

    Best Regards

    Janey Guo