Function

J

jandem

I am doing a timesheet for our office. I want to have a cell that show
the amount of overtime. The best way for me to phrase this is " i
cell N28 I have the total amount of hours worked for the week, in cel
O28 Iwant the amount of hours of overtime (anything over 40 hours
listed without having "-40" being left in the cell if the hours are no
over 40". Is there a way I can do this? Is there a function out ther
somewhere that I can copy? Thank you for help with this
 
J

JE McGimpsey

One way:

O28: =MAX(0,40-N28)

or, if you'd prefer the null string:

O28: =IF(N28>40,40-N28,"")
 
Top