Answer to Question #10634 in Other Programming & Computer Science for Adi
for eg: Start time 11:00:00 and Stop time 11:30:00 so the difference is 0:30:00 in hh:mm:ss format.
i need to use conditional formatting on the third column with the set of icons meeting the conditions
if the time is = 0:30:00 then exclamation mark symbol (!)
if the time is < 0:30:00 then correct mark symbol
and if the time is > 0:30:00 then (X) mark symbol
(X) Mark symbol when value is greater than 0.020833334 (Note the 4 at the end)
Exclamation Mark when value is <= 0.020833334 and >= 0.020833333 (Note the 3 at the end)
Tick Mark when value is < 0.020833333 (Note the 3 at the end)
Set to Reverse icon order
Need a fast expert's response?Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!