Return a value based on time range

Hi PWSNEALE ,

Please try this way:

SHIFT = 
VAR CurrentTime = 'Table'[time]
VAR StartTime_1st = TIME(6, 0, 0)
VAR EndTime_1st = TIME(14, 30, 0)
VAR StartTime_2nd = EndTime_1st
VAR EndTime_2nd = TIME(24, 30, 0)
RETURN
    IF(
        AND(CurrentTime >= StartTime_1st, CurrentTime < EndTime_1st),
        "1st shift",
        IF(
            OR(
                AND(CurrentTime >= StartTime_2nd, CurrentTime < EndTime_2nd),
                AND(CurrentTime >= TIME(0, 0, 0), CurrentTime < StartTime_1st)
            ),
            "2nd shift",
            "3rd shift"
        )
    )

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.