Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,814
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 140
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Vacation Time by Month Steve Excel Discussion (Misc queries) 0 July 5th 07 03:30 PM
Need a formulea for calculating a month drizzy Excel Discussion (Misc queries) 3 April 30th 07 07:26 AM
Calculating Month Name RestlessAde Excel Discussion (Misc queries) 2 August 1st 05 10:10 PM
Calculating recurring date in following month, calculating # days in that period Walterius Excel Worksheet Functions 6 June 4th 05 11:21 PM
Calculating days in a month STFC Excel Discussion (Misc queries) 23 January 26th 05 05:58 PM


All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"