Skip to Content
0

Days except weekends

May 09, 2017 at 01:05 PM

34

avatar image

Hi gurus, I would like to ask you for your help,

I need to create column with difference between two dates (only in working hours and without weekend). For now, I have this formula:

Calculation of wokring hours (8:00-16:30) is ok:

but when I want except weekend days, its not working and I don't know why.

Thank you for your answers

formula-3.jpg (47.7 kB)
casy-1.jpg (17.1 kB)
vikend.jpg (43.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters May 09, 2017 at 02:40 PM
0
Share
10 |10000 characters needed characters left characters exceeded