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(I28,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.

"Mike" wrote:

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