[RESOLVED] Is Current Time Between 9pm and 3am?

[leinad31]

People often overlook day spanning when tackling duration, they often just consider duration within the day (often duration during daytime)... for intervals above consider them all in day zero, or a datetime variable with value from 0 to less than 1 (unit of measure of datetime data type is a day, decimal portion or less than 1 or part of a day is the time info)... so 3AM (day zero) can be created with datetime_variable = TimeSerial(3). 3AM the next day (plus one day) would be datetime_variable = 1 + TimeSerial(3).

So you only needed to add 3AM the next day in your list of intervals using datetime data type, or you only needed to add to the list your same starting time but for the next day, in order to make the list span 24 hours. When time being considered is less than start time then just add 1 to it, it would then fall on last interval.