Hi! I want to calculate time that falls within a specific intervall. I want 1 column for weekend hours, 1 for evening hours and 1 for night hours. The rules would be as stated beneath. How would I do this? My time columns are "start" and "**bleep**". If you know how to do this I would be super happy for a specific solutions since I usually get things messes up when I have to alter to much on my own 🙂
Weekend
I want to calculate all hours for a booking if it is within saturday 06.00 (6am) and monday 06.00 (6am)
Evening
Applies 19.00 (7pm) to 22.00 (10pm) monday to friday
Night
Applies 22.00 (10pm) to 06.00 (6am) monday to saturday
