time calculation on working hours less weekend

[heber77]

Hi I am Struggling to solve this!

I need to calculate time between two dates, but need to be only between 8:00 AM and 5:00 PM, excluding weekends.
I got some results, but when the start time is over 5:00 pm still add the time...
example below:

Start End Transmission time (h:mm)
28/09/2019 18:41 30/09/2019 9:29 ?

kind regards
Heber

[XLent]

where start datetime in A1, and end datetime in B1

Please Login or Register  to view this content.

above c/o daddylonglegs - a contributor here a few years back...
obviously you can add public holiday ranges to NETWORKDAYS etc if required.

[heber77]

Great!..... Thank you!!!