Another option:

=MAX(0,A1-40)



PhAnToMiCe71898 wrote:

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

--

Dave Peterson