Calculating "greater than" after time difference worked out

1. 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

2. Re: Calculating "greater than" after time difference worked out

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

3. Re: Calculating "greater than" after time difference worked out

You could also use a formula like this

=IF(A1>"4:00"+0,.....

or

=IF(A1*24>4,......

4. Re: Calculating "greater than" after time difference worked out

Hi. That worked perfectly. Thanks a million

There are currently 1 users browsing this thread. (0 members and 1 guests)