Checking if a shift start time falls within a night period starting the day before and finishing today
Budget: £10 – £20 GBP
I'd like to create a function in a workbook that looks at a column with the start time of a work shift and tells me if that start time falls within a period which crosses the previous day (10pm to 8am). I need a formula for a cell which allows me to get an answer YES or NO.