PLEASE DON'T SHOUT! IT IS NOT POLITE.
Not sure I understand the question, but it sounds like you need something
like this.
=IF(A140,A1-40,0)
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in
"PhAnToMiCe71898" wrote in message
...
I NEED HELP WITH A FORMULA ON EXCEL!!!!!!!!!!!!! I HAVE THE WORKSHEET
COMPLETE BUT I NEED TO CALCULATE THE HOURS FOR EACH PERSON TO SHOW 40 IF
NEED
FOR WEEKLY COLUMN AND I HAVE A OVETIME COLUMN THAT NEED TO SHOW JUST OVER
TIME
I HAVE THA COLUMN DONE BUT I CAN GET THE HOURS TO SHOW 40 IS OVERTIME IS
PRESENT BUT I NO OVERTIME IS PRESENT IT STILL SHOWS 40 NOT ACTUAL HOURS
SOME
ONE PLEASE HELP ME