Decimal to Hour conversion WITH Conditional Formatting - Yikes!

Greetings! I'll try and make this short and sweet! I need to conditional format a cell if number of total hours worked(Decimal) does NOT equal the total TIME worked (h:mm) ...

We have a time sheet where we fill in both Start and Stop TIME for the day and than a section to add number, in DECIMAL, hours worked on a project. At the bottom are the totals for the projects in DECIMAL and the total work hours based on start and stop TIMES

Start Work: 08:00 (8am)
Stop Work: 17:30 (5pm)
---------------------
Project 1: 3.5 (hours - decimal)
Project 2: 4 (hours - decimal)
Project 3: 2 (hours - decimal)
---------------------
Time Working: 9:30 HOURS (Formula: 17:30-08:00)
Total Project Time: 9.5 DECIMAL
---------------------

I need to compare the Project time with Working Time and highlight the WORKING TIME cells if they are not equal.

I cant change the formatting of the fields so I need to convert the numbers. What I did was this in a blank cell to verify it worked (where D29 is the DECIMAL number 9.5)
=TEXT(D29/24,"h:mm") ==> This worked; the cell value was shown as 9:30 (from 9.5)

I thought I had it solved so I setup conditional formatting as follows on the TIME WORKING cell:
Cell Value not equal to =TEXT(D29/24,"h:mm") --> Format cell with RED FILL

The way I read that is it should turn the cell RED only if the 9:30 did value did not equal the calculated and converted 9:30. Sadly the cell stays red no mater what I do!

I have beaten my head against wall here - any ideas???

Hi and welcome to the board

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!