[freeseco]

Originally Posted by Chrissy Scivicque

This template was submitted by Jennifer Muhr. She says, "I'm a new member and wanted to share an excel vacation tracking template which you may find useful if you are an administrator who supports multiple individuals. I created this spreadsheet along with a colleague."

Instructions are outlined in the first tab of the spreadsheet.

I keep a log of all V and P days for my entire company. Does this report have the ability to have a monthly calendar that will show each person off on a day without having to open each individuals tab?

Thanks,
Mandy

[J William]

Does anyone know of a way to capture all of the individual employee's time off entries into a monthly snapshot...where you can have a quick way to see who all is off on a particular day or timeframe?

Thanks!
Jill

[Pesolira]

Originally Posted by Jmk

Short instruction assuming the name of Abraham Green as a new employee:

1. Insert a new worksheet and name it Green 09
2. Copy (with Ctrl-A, Ctrl-C) the contents of the worksheet Jones 09 into Green 09
3. Write the name of Abraham Green into the cell D3 of Green 09 worksheet
4. In Total worksheet insert a row between rows 6 and 7
5. Copy the contents of B8:T8 into A7:T7
6. Mark A7:T7 and change (with Ctrl-H) Jones into Green within the marked area
7. Make a hyperlink in B7 to the worksheet Green 09

Repeat for all the new employees.
This Absence and Vacation Tracker does not provide any automatization of the process.

Thank you so much for this sheet. I really want to use it, but I am having a problem adding the new employees. How do I do the hyper link? Am I really to copy B8:T8 and paste into A7:T7? I believe I would be pasting into A8:T8 instead. Please clarify.

Thank you very much.

[LatinaLV]

Wow! This spreadsheet is absolutely awesome! Thanks so much for sharing it with us!

[grainger]

Originally Posted by trhoton

I like the tracker and could find it useful for our tracking; however, we use vacations by the hour so someone couold take 1 hour of vacation which has been complicated to track. what adjustment to the formula is needed to convert it from days to hours?
Thanks,
T

I found this tracker so helpful and it will be a great tool for me to use. I too need to track vacations in terms of hours. Can anyone let me know if this is possible and how i would adjust the formula?

Cheers

[ThereseMN]

Originally Posted by Chrissy Scivicque

This template was submitted by Jennifer Muhr. She says, "I'm a new member and wanted to share an excel vacation tracking template which you may find useful if you are an administrator who supports multiple individuals. I created this spreadsheet along with a colleague."

Instructions are outlined in the first tab of the spreadsheet.

I too use an excel spreadsheet for tracking vacation days.

Employees where I work earn vacation days depending on how many years they've been with the company. Formula is run off their hire date. Once you plug in a hire date MM/DD/YYY it formulates how many vacation days they earn: <5 years : 10 days; 6-10 years : 15 days; 11-15 days : 20 days; >16 years : 25 days.

[tahtah]

Many Thanks

[mrozalen]

really useful.... !!

[quin1029tos]

I'm a new member too. This doc is truly helpful thanks for sharing it.