Hi everyone,
I'm trying to calculate the exact day shift hours and the exact night shift hours.
The day hours are from 9:00 to 18:00 and the night shift hours are from 18:00 to 9:00.
I just can't get any formula to do what I need it to do.
I would really appreciate any help on this, I'm going nuts here!![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I'm trying to calculate the exact day shift hours and the exact night shift hours.
The day hours are from 9:00 to 18:00 and the night shift hours are from 18:00 to 9:00.
I just can't get any formula to do what I need it to do.
I would really appreciate any help on this, I'm going nuts here!
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)