LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John
 
Posts: n/a
Default Date functions

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
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
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Complex Date Functions Simon Heaven Excel Worksheet Functions 6 November 6th 09 05:11 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
Date functions for dates pre-1900 Stephen Larivee Excel Discussion (Misc queries) 2 July 20th 05 08:23 PM
Date functions Dale Excel Discussion (Misc queries) 5 April 10th 05 01:45 PM


All times are GMT +1. The time now is 08:30 PM.

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

About Us

"It's about Microsoft Excel"