Subtract non-working hours

[EmptyCarSpot]

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

[v-janeyg-msft]

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