=IF(H:H = "8AM-12PM","8:00 AM",
IF(H:H = "12PM-4PM","12:00 PM",
IF(H:H = "4PM-7:30PM","4:00 PM",
IF(H:H = "AM(6:30AM-1:30PM)","6:30 AM",
IF(H:H = "6:30 AM-1:30 PM","6:30 AM",
IF(H:H = "PM(1:30PM-CLOSE)","1:30 PM",
IF(H:H = "1:30PM-7:30PM","1:30 PM", "lolsorry")
)
)
)
)
)
)
=IF(H:H = "8AM-12PM","12:00 PM",
IF(H:H = "12PM-4PM","4:00 PM",
IF(H:H = "4PM-7:30PM","7:30 PM",
IF(H:H = "AM(6:30AM-1:30PM)","1:30 PM",
IF(H:H = "6:30 AM-1:30 PM","1:30 PM",
IF(H:H = "1:30PM-7:30PM","7:30 PM",
IF(H:H = "PM(1:30PM-CLOSE)","7:30 PM", "lolsorry")
)
)
)
)
)
)
=REGEXEXTRACT(C:C, "^(.*?),")
=REGEXEXTRACT(C:C, "\, (.*, NC) [0-9]+$")
=REGEXEXTRACT(C:C, "[0-9]+$")