| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a vacation report using hours alloted based on hir
Hello,
I've been trying to create a vacation report based on hire date to determine the yearly allotment of hours. No luck so far. Any help would be greatly appreciated. Earl |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set up a vacation report using hours alloted based on hir
As a start and with no details,
Look at the datedif function http://www.cpearson.com/excel/datedif.htm Only documented in help for xl2000, but available in all versions. Once you figure out how many months, days, or years, then possibly use Choose or some multiplier or use a vlookup table. -- Regards, Tom Ogilvy "EW" wrote in message ... Hello, I've been trying to create a vacation report based on hire date to determine the yearly allotment of hours. No luck so far. Any help would be greatly appreciated. Earl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Length of Service and Vacation Hours Accrued | Excel Worksheet Functions | |||
| I want a spreadsheet to track employee vacation/sick time hours | Charts and Charting in Excel | |||
| how to set excel to track attendance and vacation hours available | Excel Discussion (Misc queries) | |||
| Keeping track of Sickdays, Vacation days, and hours for each. | Excel Worksheet Functions | |||
| Vacation accrual based on hours worked - Excel 2003 | Excel Worksheet Functions | |||
Hybrid Mode
