IF Statement with twelve conditions for time conditioning

[Jescanilla]

Hi everyone as the tittle says im trying to use twelve if statement to categorize different times but the formula its getting huge, im trying to do it separately and then unit it, but if i overlap a condition i start geting errors.
Its there a easy way to do it?
this is the table of conditions that im trying to do.

i couldnt copy the entire table cuz it was to wide but here its an example.

Horometro semanal.xlsx
	B	C	D	E	F	G
2	0:00		PISO		PISO
3	0:05		PISO		PISO
4	0:10		PISO		PISO
5	0:15		PISO		PISO
6	0:20		PISO		PISO
7	0:25		PISO		PISO
8	0:30		PISO		PISO
9	0:35		PRIMERA	FALSE	PRIMERA
10	0:40		PRIMERA	FALSE	PRIMERA
11	0:45		PRIMERA	FALSE	PRIMERA
12	0:50		PRIMERA	FALSE	PRIMERA
13	0:55		PRIMERA	FALSE	PRIMERA
14	1:00		FALSE	FALSE	FALSE
15	1:05			FALSE	FALSE
16	1:10			FALSE	FALSE
17	1:15			FALSE	FALSE
18	1:20			FALSE	FALSE
19	1:25			FALSE	FALSE
20	1:30			FALSE	FALSE
21	1:35			FALSE	FALSE
22	1:40			FALSE	FALSE
23	1:45			FALSE	FALSE
24	1:50			FALSE	FALSE
25	1:55			FALSE	FALSE
26	2:00			FALSE	FALSE
27	2:05			FALSE	FALSE
28	2:10			FALSE	FALSE
29	2:15			FALSE	FALSE
30	2:20			FALSE	FALSE
31	2:25			FALSE	FALSE
32	2:30			FALSE	FALSE
33	2:35			FALSE	FALSE
34	2:40			FALSE	FALSE
35	2:45			FALSE	FALSE
36	2:50			FALSE	FALSE
37	2:55			FALSE	FALSE
38	3:00			FALSE	FALSE
39	3:05			FALSE	FALSE
40	3:10			FALSE	FALSE
41	3:15			FALSE	FALSE
42	3:20			FALSE	FALSE
43	3:25			FALSE	FALSE
44	3:30:00			RELEVO	RELEVO
45	3:35:00			FALSE	RELEVO
46	3:40:00			FALSE	RELEVO
47	3:45:00			FALSE	RELEVO
48	3:50:00			FALSE	RELEVO
49	3:55:00			FALSE	RELEVO
50	4:00:00			FALSE	RELEVO
51	4:05:00			FALSE	RELEVO
52	4:10			FALSE	RELEVO
53	4:15			FALSE	RELEVO
54	4:20			FALSE	RELEVO
55	4:25			FALSE	RELEVO
56	4:30			RELEVO	RELEVO
57	4:35			FALSE	RELEVO
58	4:40			FALSE	RELEVO
59	4:45			FALSE	RELEVO
60	4:50			FALSE	RELEVO
61	4:55			FALSE	RELEVO	FALSE
62	5:00			FALSE	FALSE	RELEVO
63	5:05			FALSE	FALSE	RELEVO
64	5:10			FALSE	FALSE	RELEVO
65	5:15			FALSE	FALSE	RELEVO
66	5:20			FALSE	FALSE	RELEVO
67	5:25			FALSE	FALSE	RELEVO
68	5:30			RELEVO	RELEVO	RELEVO
69	5:35			FALSE		FALSE
70	5:40			FALSE		FALSE
71	5:45			FALSE		FALSE
72	5:50			FALSE		FALSE
73	5:55			FALSE		FALSE
74	6:00			FALSE		FALSE
75	6:05			FALSE		FALSE
76	6:10			FALSE
77	6:15			FALSE
78	6:20			FALSE
79	6:25			FALSE
80	6:30			FALSE
81	6:35			FALSE
82	6:40			FALSE
83	6:45			FALSE
84	6:50			FALSE
85	6:55			FALSE
86	7:00			FALSE
87	7:05			FALSE
88	7:10			FALSE
89	7:15			FALSE
90	7:20			FALSE
91	7:25			FALSE
92	7:30			FALSE
93	7:35			FALSE
94	7:40			FALSE
95	7:45			FALSE
96	7:50			FALSE
97	7:55			FALSE
98	8:00			FALSE
99	8:05			FALSE
100	8:10			FALSE
101	8:15			FALSE
102	8:20			FALSE
103	8:25			FALSE
104	8:30			FALSE
105	8:35			FALSE
106	8:40			FALSE
107	8:45			FALSE
108	8:50			FALSE
109	8:55			FALSE
110	9:00			FALSE
111	9:05			FALSE
Sheet2

Cell Formulas
Range	Formula
D2:D14	D2	=IF(AND(HOUR(B2)>=0,MINUTE(B2)>=0,HOUR(B2)<=0,MINUTE(B2)<=30),"PISO",IF(AND(HOUR(B2)>=0,MINUTE(B2)>=30,HOUR(B2)<=0,MINUTE(B2)<=59),"PRIMERA"))
F2:F43	F2	=IF(AND(HOUR(B2)>=0,MINUTE(B2)>=0,HOUR(B2)<=0,MINUTE(B2)<=30),"PISO",IF(AND(HOUR(B2)>=0,MINUTE(B2)>=30,HOUR(B2)<=0,MINUTE(B2)<=59),"PRIMERA"))
F44:F68	F44	=IF(AND(HOUR(B44)>=3,MINUTE(B44)>=30,HOUR(B44)<=5,MINUTE(B44)<=59),"RELEVO",IF(AND(HOUR(B44)>=4,MINUTE(B44)>=0,HOUR(B44)<=4,MINUTE(B44)<=29),"RELEVO"))
G61:G75	G61	=IF(AND(HOUR(B61)>=5,MINUTE(B61)>=0,HOUR(B61)<=5,MINUTE(B61)<=30),"RELEVO")
E9:E42	E9	=IF(AND(HOUR(B9)>=3,MINUTE(B9)>=30,HOUR(B9)<=5,MINUTE(B9)<=29),"RELEVO")
E43	E43	=IF(AND(HOUR(B43)>3,MINUTE(B43)>=30,HOUR(B43)<=5,MINUTE(B43)<=29),"RELEVO")
E44:E111	E44	=IF(AND(HOUR(B44)>=3,MINUTE(B44)>=30,HOUR(B44)<=5,MINUTE(B44)<=30),"RELEVO")

 

[offthelip]

You can use vlookup if you create a table of times like this, I put this on sheet 2:

Book1
	A	B
1
2	00:00	PISO
3	00:30:00	Primera
4	01:00:00
5	01:30:00
6	02:00:00
7	02:30:00
8	03:00:00
9	03:30:00	Relevo
10	04:00:00	Relevo
11	04:30:00	Relevo
12	05:00:00	Relevo
13	05:30:00
14	06:00:00
15	06:30:00
16	07:00:00	Ultima
17	07:30:00	Ultima
18	08:00:00	PISO
19	08:30:00	Primera
20	09:00:00
21	09:30:00
22	10:00:00
23	10:30:00
24	11:00:00
25	11:30:00	Relevo
26	12:00:00	Relevo
27	12:30:00	Relevo
28	13:00:00	Relevo
29	13:30:00
30	14:00:00
31	14:30:00
32	15:00:00	Ultima
33	15:30:00	Ultima
34	16:00:00	PISO
35	16:30:00	Primera
36	17:00:00
37	17:30:00
38	18:00:00
39	18:30:00
40	19:00:00
41	19:30:00	Relevo
42	20:00:00	Relevo
43	20:30:00	Relevo
44	21:00:00	Relevo
45	21:30:00
46	22:00:00
47	22:30:00
48	23:00:00	Ultima
49	23:30:00	Ultima
Sheet2

Cell Formulas
Range	Formula
A3:A49	A3	=A2+(1/48)

then get the correct text :

=VLOOKUP(A1,Sheet2!A$2:B$49,2,TRUE)

Do check that I have got the correct text at the correct time in the table

 

[Jescanilla]

Thanks for the answer.
Shame on me lol