Forum Discussion
Solved
Conditional Formatting of Time after 9:00 AM
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.
The cells contain both date and time. Use the following formula to strip off the date part:
=MOD($B1,1)>TIME(9,0,0)
2 Replies
The cells contain both date and time. Use the following formula to strip off the date part:
=MOD($B1,1)>TIME(9,0,0)
- It worked! Thank you very much!
