Function

[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

 

[rbanks]

Cell n28 =total hours
cell o28 =if(N28>40,N28-40,0

 

[JE McGimpsey]

One way:

O28: =MAX(0,40-N28)

or, if you'd prefer the null string:

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