Conditional Formatting of Time after 9:00 AM

[Jtherson]

Hello,

Please I need help with conditional formatting times after 9:00 AM. I will appreciate help as I need it for a project.

I have attached a excel containing the times.

I have tried Time(9,0,0) and =$B1>Time(9,0,0) but still does not work.

Thank you in anticipation of your assistance.

[#2 · Accepted solution]

@Jtherson 

The cells contain both date and time. Use the following formula to strip off the date part:

=MOD($B1,1)>TIME(9,0,0)

[#3]

It worked! Thank you very much!