Calculating "greater than" after time difference worked out

Hi Folks

I have calculated the difference in working time between two dates. All good so far. Output cell is in format custom format hh:mm.

I now need to see whether the above is greater than four hours. I just tried a simple if clause, but this is not working.

Has anyone any ideas?

Thanks

Hi barneyausten

Although you have formatted the cell to read hh:mm excel "sees" the value as a part of a day so the formula you need is:

=(OutputCell>.166667)

edvwvw

Hi. That worked perfectly. Thanks a million