I'm trying to identify which employees work at night. Between 6:30 and 23:00 is day time. Outside is night time (just by getting part of it). Without using VBA is there any formula in excel to this?
|1||Employee name||Work Time||Identification|
|2||Andrew||04:00 - 06:00||Night Time|
|3||Bernie||05:00 - 09:00||Night Time|
|4||Charles||04:00 - 12:00||Night Time|
|5||Diana||10:00 - 18:00||Day Time|
|6||Earl||20:00 - 02:00||Night Time|
|7||Fergie||22:30 - 08:00||Night Time|