Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi world!This is a two part question. Part One. I am trying to use a start
date (say..8/9/05) that then is used to calculate monthly vacation (eg. on 9/8/05 staff have gained 12 hrs vacation) and so every month the amount will increase by that 12hrs so by the end of their start year the total will be in theory 144. But I also of course want to be able to remove hrs when the staff member takes vacation (an obvious manual requirement). Part two, staff have a productivity requirement of 100 hours a month of billable service to clients, so every week they pretty much have to do 25 hrs, but of course if they are taking two weeks vacation then this will effect the billable hours that they have to reach. So.... the input of vacation (manually) needs also to be a function into porductivity rates. AAAAAHH! I hope this makes some sense and if you can help a little of the way I would be grateful, even if it is to say you can't do it. Ps Can Outlook be used to feed in vacation anniversary dates? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Complex Date Functions | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Date functions for dates pre-1900 | Excel Discussion (Misc queries) | |||
Date functions | Excel Discussion (Misc queries) |