Calculate time between intervall if it falls within specific time

Topic Labels: Dates & Timezones
238 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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 🙂

I want to calculate all hours for a booking if it is within saturday 06.00 (6am) and monday 06.00 (6am)

Applies 19.00 (7pm) to 22.00 (10pm) monday to friday

Applies 22.00 (10pm) to 06.00 (6am) monday to saturday

0 Replies 0