Try this not sure if this is what your needing
The -0.5 at the end is for lunch

=IF(A1<=8,A1-A1,A1-8-0.5)

"jodee501" wrote:

I have a timesheet that calculates the time then takes out lunch & if over 8
hours put overtime in a column, but if the time is less than 8 it shows
negative ot instead of -0-. help !!!!