Help

Calculate time between intervall if it falls within specific time

Topic Labels: Dates & Timezones
238 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Pingvinen
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 🙂

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

0 Replies 0