Time Sheet

[Gary Davis]

Hello All,

I am writing a time sheet for work.
C 11 thru I 11 has the actual hours worked each day J 11 has the
total hours worked for the week (sum c11:I11). What I am trying to do
is have J11 show only 40 hours if the work week was over 40 hours. I
want to have the overtime hours in the cell below on J12.

I have entered a formula in J12 as sum (c11:I 11 -40) this works good
if there is overtime but shows a neg number if no overtime.

Can anyone help with the formula in these two cells



Thanks
Gary Davis

 

[Peo Sjoblom]

Try

=MIN(40,SUM(C11:I11))

in J12

=MAX(0,SUM(C11:I11)-40)

 

[Franz]

Hello All,

I am writing a time sheet for work.
C 11 thru I 11 has the actual hours worked each day J 11 has the
total hours worked for the week (sum c11:I11). What I am trying to do
is have J11 show only 40 hours if the work week was over 40 hours. I
want to have the overtime hours in the cell below on J12.

I have entered a formula in J12 as sum (c11:I 11 -40) this works good
if there is overtime but shows a neg number if no overtime.

Check out Chip Pearson's site
http://www.cpearson.com/excel/overtime.htm
http://www.cpearson.com/excel/DateTimeEntry.htm

 

[Gary Davis]

Thank you all very much. It is a big help

Check out Chip Pearson's site
http://www.cpearson.com/excel/overtime.htm
http://www.cpearson.com/excel/DateTimeEntry.htm