Conditional format time

[Vtookup]

Hi all.
I have a column of results. counting how many hours a task takes. if it exceed 5:00 (Formatted to time 13:30) the text should turn red.
tried conditional format greater than, it doesn't work and don't know what formula to use. I know time is tricky and i'm blank with this.
Can someone help? Thanks

 

[jim may]

If your cell displays 5:00 with the cell formatted with the 13:30 choice from the Format dialog the cell ACTUALLY CONTAINS the VALUE .208333 (or 5/24).
So maybe try "> 5/24"

 

[MARK858]

Maybe (using yellow rather than red below just because it displays better on the board)...

Excel Workbook
	A
1	06:30
2	04:00
3	05:30
4	10:50
5	03:30
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A1>TIMEVALUE("05:00")	Abc

 

[Vtookup]

Hi again.
Thanks for the quick replies. I got this formula from an online help
to clarify,Im using this formula =TEXT(C3-B3+(C3 < B3)+(E3-D3+(E3 < D3)),"h:mm")
what do you think is the correct format for the result? @jim may, maybe my format is wrong.
I tried MARK858's approach, even 5:00 got highlighted, same with the blanks.
what do you think is wrong? Thanks again.

 

[MARK858]

In an empty cell put

=ISNUMBER(A1)

changing the A1 to the cell containing the 05:00, is the result FALSE?
It should be, as the formula

=TEXT(C3-B3+(C3 < B3)+(E3-D3+(E3 < D3)),"h:mm")

would return a text result and so it is not a real time in the cell.

what does

=C3-B3+(C3 < B3)+(E3-D3+(E3 < D3))

return (a bit concerned what effect the < tests is having)?

 

[Vtookup]

Hi MARK858.
I have removed the TEXT and format in the formula. now it is working.
Thank You.

 

[MARK858]

You're welcome