AND with condition of time

[lezawang]

Hi the formula below is not working

=AND(B41="HR",C41>"8:00 am")

The problem is with C41>"8:00 am"

Any idea would be appreciated it. Thank you very much

ifs.xlsx
	A	B	C	D
40	Name	Dept	Start Time	Dept =HR , Start Time > 8:00
41	Mary	IT	8:17 AM	FALSE
42	Alex	Sales	8:04 AM	FALSE
43	David	HR	8:10 AM	FALSE
44	Sarah	Marketing	7:59 AM	FALSE
45	Linda	HR	8:14 AM	FALSE
46	Tam	IT	8:17 AM	FALSE
47	Sam	Sales	7:59 AM	FALSE
48	Ali	HR	7:54 AM	FALSE
49	Eric	Marketing	8:20 AM	FALSE
50	Anna	HR	8:12 AM	FALSE
AND

Cell Formulas
Range	Formula
D41:D50	D41	=AND(B41="HR",C41>"8:00 am")

 

[jtakw]

Hi,

Try it this way:

Book3.xlsx
	A	B	C	D	E	F
40	Name	Dept	Start Time	Dept =HR , Start Time > 8:00	OR	OR
41	Mary	IT	8:17:00 AM	FALSE	FALSE	FALSE
42	Alex	Sales	8:04:00 AM	FALSE	FALSE	FALSE
43	David	HR	8:10:00 AM	TRUE	TRUE	TRUE
44	Sarah	Marketing	7:59:00 AM	FALSE	FALSE	FALSE
45	Linda	HR	8:14:00 AM	TRUE	TRUE	TRUE
46	Tam	IT	8:17:00 AM	FALSE	FALSE	FALSE
47	Sam	Sales	7:59:00 AM	FALSE	FALSE	FALSE
48	Ali	HR	7:54:00 AM	FALSE	FALSE	FALSE
49	Eric	Marketing	8:20:00 AM	FALSE	FALSE	FALSE
50	Anna	HR	8:12:00 AM	TRUE	TRUE	TRUE
Sheet889

Cell Formulas
Range	Formula
D41:D50	D41	=AND(B41="HR",C41>8/24)
E41:E50	E41	=AND(B41="HR",C41>TIME(8,0,0))
F41:F50	F41	=AND(B41="HR",C41>TIMEVALUE("8:00 am"))