It would help if you posted the formula you're using, but I'll guess that
you're comparing to the number 40. If you've got everything in time format,
you probably want to compare to 40/24 instead (40 would be 40 days; 40/24
makes it 40 hours).

"DonElston" wrote:

Trying to calculate Overtime using IF THEN. All cells are formatted for time.

If E22 is greater than 40 hours, I want 40, else E22. E22 is 51:00:00 and
the statement keeps comming back with the full 51:00:00.

Excel 2007.

Thanks in advance, I know it is something simple but after 45 minutes, I'm
fed up

Don