Can I do conditional formatting based on time?

[Patikns23]

I have this spreadsheet that shows time clocked in by employee. There are two starting times - 5am and 5pm. I would like to conditionally highlight all times that are either after 5:00:00 AM if the time is AM and after 5:00:00 PM if the time is PM. If the cells are blank (days not worked), I would like no conditional formatting to be applied.

Is there a way to do this?

Thank you.

 

[awoohaw]

Does this work for you?

Mr Excel Questions.xlsx
	A	B	C	D
1
2			5:05 AM
3			5:03 AM
4			4:55 AM
5
6			5:04 AM
7			4:56 AM
8			4:55 PM
9			4:58 PM
10
11			5:03 PM
12			4:56 PM
13			5:00 PM
14
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:C13	Expression	=OR(AND(C2>TIME(5,0,0),C2<TIME(12,0,0)),AND(C2>TIME(17,0,0),C2<1))	text	NO

 

[awoohaw]

@Patikns23, did the answer above solve your question?