Template for tracking employee vacation, sick and personal time

[Tttimw]

Is anyone familair with an excel spreadsheet, or word document one could use
to track employees vacation, sick and/or personal time?

 

[Gary Brown]

Cell A1: Emp Name/Emp #
Cell B1: Category
Cell C1: Date
Cell D1: Hrs
Cell E1: Month
Cell F1: Day

In Col A, put employee name or employee #
In Col B, put P for personal, S for Sick, V for Vacation
In Col C, put the date time was taken
In Col D, put # of hrs used. 8 for a full day, 4 for a half day, etc
In Col E, formula so you can filter on month
=MONTH(C2)
In Col F, formula so you can watch if the employee likes to take Mondays off
=CHOOSE(MOD(C2,7)+1,"Sat","Sun","Mon","Tue","Wed","Thu","Fri")

Add a filter and/or sumif's for each employee for P,S and V.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown

 

[Gord Dibben]

MS Template Gallery

http://office.microsoft.com/en-us/templates/results.aspx?qu=absence&av=TPL000


Gord Dibben MS Excel MVP