Hi,
I calculate the difference between two times and i got the result using the below formula.
Example:-
A2= 17/03/2014 10:00:00 AM , B2 = 17/03/2014 5:00:00 PM , Result :- 7:00
Formula is " =TEXT(A2-B2,"[H]:MM") "
If I want to Highlight with red font for the values more than 04:00 how to select the same from Excel Sheet by using conditional format or any other option.
Please help.
Bookmarks