Hi,

Suppose you have a work sheet with the following Data:
A B C D E F
1 10 10 10 12 42 2

In cell F1 you can use the following formula =IF(E140,E1-40,"-")

--
Rani


"kjkkd" wrote:

Excel 2003
I have set up a spread sheet to track work hours. So when the cell with
total hours worked for the week hits 40 I want the overtime hours in another
cell. Can anybody help?

Thanks