Time sheet problem

K

kjkkd

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
 
A

AnisaF

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,"-")
 
Top