Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Time by Month
I am working on a project where I have to calculate vacation time from 1/07
(this will change to each new year) to the last day of the previous month. The calc needs to look at the hire date and if the employee was hired after the 15th of the month, then the vacation time calc would not occur until the end of the next month. This has to update each time it is opened based on the parameters above until the end of the year. Also Different level employees accumulate vacation time @ different rates (i.e.: .67 days per month, .83 days per month, or 1.33 days per month). I understand that I will have to input the different vacation rates for each employee and work the hire date into the calculation. But because of the use of the dates and the other parameters above I have gotten myself totally lost. I found the following web page: http://www.cpearson.com/excel/datetime.htm AddingTimes hoping that it would help me. But it has only confused me more. I was hoping this would be simple problem .... guess not. Any suggestions? Thx in advance, Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Time by Month
Hi Steve
Sadly no specific advise to give - just general advise that I use when planning a spreadsheet application Break it all down into smaller processes - that way they are easier to work with as an example to begin with keep your employee start dates separate to your vacation accrual - ie separate worksheets could work here. On each work sheet - calculate only the needed infor to do with that topic. Finally you can start linking all the seperate info together into the final solution HTH "Steve" wrote: I am working on a project where I have to calculate vacation time from 1/07 (this will change to each new year) to the last day of the previous month. The calc needs to look at the hire date and if the employee was hired after the 15th of the month, then the vacation time calc would not occur until the end of the next month. This has to update each time it is opened based on the parameters above until the end of the year. Also Different level employees accumulate vacation time @ different rates (i.e.: .67 days per month, .83 days per month, or 1.33 days per month). I understand that I will have to input the different vacation rates for each employee and work the hire date into the calculation. But because of the use of the dates and the other parameters above I have gotten myself totally lost. I found the following web page: http://www.cpearson.com/excel/datetime.htm AddingTimes hoping that it would help me. But it has only confused me more. I was hoping this would be simple problem .... guess not. Any suggestions? Thx in advance, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Vacation Time by Month | Excel Discussion (Misc queries) | |||
Need a formulea for calculating a month | Excel Discussion (Misc queries) | |||
Calculating Month Name | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating days in a month | Excel Discussion (Misc queries) |