| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Overtime hours in a spreadsheet | Excel Discussion (Misc queries) | |||
| Formula to Compute Overtime hours | Excel Worksheet Functions | |||
| overtime hours formula | Excel Worksheet Functions | |||
| if then formula for total time ;overtime hours versus regular | Excel Worksheet Functions | |||
| need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Linear Mode
