NEED HELP WITH FORMULA FOR CALC HOURS AND OVERTIME

[PhAnToMiCe71898]

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

 

[Robin Hammond]

PLEASE DON'T SHOUT! IT IS NOT POLITE.

Not sure I understand the question, but it sounds like you need something
like this.

=IF(A1>40,A1-40,0)

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in

 

[Dave Peterson]

Another option:

=MAX(0,A1-40)

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