NEED HELP WITH FORMULA FOR CALC HOURS AND OVERTIME
 

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

NEED HELP WITH FORMULA FOR CALC HOURS AND OVERTIME
 

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

NEED HELP WITH FORMULA FOR CALC HOURS AND OVERTIME
 

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