Using IF with elapsed time

[ETGREENE]

I hope this hasn't been asked before. I looked before posting. I am trying to build a formula similar to:
=IF(D6*24>("40:00"),D6,IF(D6*24=("40:00"),"40:00",IF(D6*24<("40:00"),"40:00")))

Where cell six lets say is 32:57. Excel is fighting me on what the [h]:mm:ss actually means.

It's converting it to a decimal value behind the scenes.
My creation is to express if the total of a persons hours worked is equal to or more than 40 then the 40 hours would be displayed, and if they worked less than 40 hours then it would display the actual hours and minutes worked.

Any help would be greatly appreciated.

 

[bebo021999]

When D6 multifly to 24, it should change "40:00" to 40.
BTW, the formula should be:

=MIN(D6,40/24)

Assum D6 is in proper time format.

 

[ETGREENE]

Thank you, I had to fight it so long. Too bad it always changes time behind the scenes.