need help w/ formula for taking lunch & overtime out of a 9 hour
Sorry
This sould do better
what i did was change the 8 to 8.5
=IF(A1<=8.5,A1-A1,A1-8.5-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 !!!!
|