quiero que aparesca un texto despues de validar un rango de horas.
Turnos
06:00:00 14:29:00 Turno 1
14:30:00 22:59:00 Turno 2
23:00:00 05:59:00 Turno 3
=SI($F13>=L14,"Turno 1",SI($F13<=M14,"Turno 1",SI($F13>=L15,"Turno
2",SI($F13<=M15,"Turno 2",SI($F13>=L16,"Turno 3",SI($F13<=M16,"Truno
3","Turno no valido"))))))
01:00:00 que indice el turno
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:30:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
00:00:00
Leer las respuestas