Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Length of Service and Vacation Hours Accrued
IF Statement would be If 0-60 months 8 Hours accrued each month, if
61-120 months 10 hours accrued each month, If 121-180 months 12 hours accrued each month, if more than 181 months then 14 hours accrued each month. When I try to put in an argument I get an error message. **This accrual amount for each month must be used in the monthly column if the worksheet for that month has 100% for the hours worked in cell C02 of each month. i.e.,: Column A Column B (Month) (Earned)** JULY-08 ________ (see the description above) AUG-08 SEPT-08 OCT-08 NOV-08 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Length of Service and Vacation Hours Accrued
Dear William
I am not sure how you are calculating the total months..I will give an example which will help..Suppose A1 = Start Date B1 = End Date The below forumla will calculate the total months between this dates and get the hours accrued based on months and then calulate the total hours accrued. Please try and feedback =LOOKUP(DATEDIF(A1,B1,"m"),{0,61,121,181},{8,10,12 ,14})*DATEDIF(A1,B1,"m") A break down of the formula to help you in future =DATEDIF(A1,B1,"m") will give you the months between dates =LOOKUP("<value",{0,61,121,181},{8,10,12,14}) will lookup the corresponding hours based on the total months If this post helps click Yes --------------- Jacob Skaria "WilliamsDeLisle" wrote: IF Statement would be If 0-60 months 8 Hours accrued each month, if 61-120 months 10 hours accrued each month, If 121-180 months 12 hours accrued each month, if more than 181 months then 14 hours accrued each month. When I try to put in an argument I get an error message. **This accrual amount for each month must be used in the monthly column if the worksheet for that month has 100% for the hours worked in cell C02 of each month. i.e.,: Column A Column B (Month) (Earned)** JULY-08 ________ (see the description above) AUG-08 SEPT-08 OCT-08 NOV-08 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Length of Service and Vacation Hours Accrued
This helped a great deal. Thank you.
"WilliamsDeLisle" wrote: IF Statement would be If 0-60 months 8 Hours accrued each month, if 61-120 months 10 hours accrued each month, If 121-180 months 12 hours accrued each month, if more than 181 months then 14 hours accrued each month. When I try to put in an argument I get an error message. **This accrual amount for each month must be used in the monthly column if the worksheet for that month has 100% for the hours worked in cell C02 of each month. i.e.,: Column A Column B (Month) (Earned)** JULY-08 ________ (see the description above) AUG-08 SEPT-08 OCT-08 NOV-08 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Formula for Calculating Accrued Vacation Time | Excel Worksheet Functions | |||
Vacation Accrued | Excel Discussion (Misc queries) | |||
How do I add "accrued vacation days" column to the Employee Attend | Excel Worksheet Functions | |||
Length of Service | Excel Worksheet Functions | |||
Accrued Vacation | Excel Worksheet Functions |