Time sheet problem

[Guest]

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

 

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

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(E1>40,E1-40,"-")