Formula

[Guest]

I am trying to create a timecard and I need to calculate overtime. I am
trying an if function. =if(i2>8,i2-8,i2+0) where i2 is total hours and I am
using j2for ot. Thank you.

 

[Guest]

Hi Mike,

Assuming you're putting that formula in the j2 cell for the OT you're trying
to calculate, then the formula should be:

=IF(I2>8,I2-8,0)

This will give you the OT hours if more than 8 hours are worked and 0 hours
if 8 or less hours will work.

 

[joeu2004]

I am trying to create a timecard and I need to calculate overtime.
I am trying an if function. =if(i2>8,i2-8,i2+0) where i2 is total hours
and I am using j2 for ot.

If you are trying to compute I2-8 or zero for OT in J2, try:

=max(0, I2-8)

PS: OT is often not simpy the hours in excess of 8 hours in a day.
You might want to check the OT laws in your state.