Change cell contains depends on time and date

[borg]

Hello
I have a little struggle with this
4 employees work at 12 hours shift, day shift 7:30-19:00 (7:30AM-7:00PM) and night shift 19:00-7:30 (7:00PM-7: 30AM)
Question: how to make in cell A1 show employee name depends on date and time?

Thanks in advance

 

[Kaper]

in cell A1 show employee name depends on date and time

but where is this date/time.
Is it current moment? if yes, use such formula in A1:

=INDEX(B4:D34,MATCH(TODAY(),A4:A34,0),MATCH(NOW()-TODAY(),B2:D2,1))

If it is other time, use date in first match and time in second one.

Imprortant remark
Both: dates in column A, and times in row 2 have to be excel dates/times, not just texts looking like date/time. Easy way to check this is by changing formatting to a custom like:
"ddmmyyhhmm"

if such formatting applied to A4 produces

0108240000​

and to C2:

0001000730​

you have real dates and times in respective cells and formula shall work fine.
If not, you have either to transform your data in column A/row 2 to be real times/dates (highly recommended) or ammend formula to deal with texts (possible, but not recommended).

 

[borg]

Thanks, that now()-today() solved everything

Thanks again