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 Ti...
The cells contain both date and time. Use the following formula to strip off the date part:
=MOD($B1,1)>TIME(9,0,0)
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!
