Time sheet problem
 

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

http://www.cpearson.com/excel/overtime.htm

--
Regards,

Peo Sjoblom

(No private emails please)


"kjkkd" wrote in message
...
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

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