Vlookup a time range from different Times

[A Selim]

Hi Engineers,


I'm looking to have all cells only fail between =/> 12:00:00 AM and =/< 08:00:00 AM to give me a value like 1 or 0

Anyone can help please

BR

 

[DanteAmor]

Check if you need this

varios 03jun2020.xlsm
	J	K
1	Created Time	1/0
2	12:23:39 p.m.	0
3	10:13:26 a.m.	0
4	01:52:04 p.m.	0
5	01:05:00 a.m.	1
6	08:00:00 a.m.	1
7	12:00:00 p.m.	0
8	12:01:00 p.m.	0
9	12:01:00 a.m.	1
Hoja5

Cell Formulas
Range	Formula
K2:K9	K2	=IF(AND(J2>=TIMEVALUE("00:00:00"),J2<=TIMEVALUE("08:00:00")),1,0)

 

[A Selim]

=IF(AND(J2>=TIMEVALUE("00:00:00"),J2<=TIMEVALUE("08:00:00")),1,0)

Thanks a million, dear

This is exactly what I need.

You have made my day

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.