Tags: employee, excel, familiar, form, funeral, individual, leave, microsoft, msdn, office, program, sick, software, template, time, track, vacation

Template to track employee vacation,sick & funeral leave time?

On Microsoft » Microsoft Excel

2,388 words with 2 Comments; publish: Fri, 23 May 2008 02:13:00 GMT; (30693.75, « »)

I have Microsoft Office Excel 2003. I'm not very familiar with the program

and I need to set up of form to track individual employee's leave time. My

hopes is to have a sheet for each employee, be able to input a date, hours

requested and type of leave time (sick, vacation, or funeral) and have the

form figure the time that particular employee has left of each type of leave.

Is this possible?

All Comments

Leave a comment...

  • 2 Comments
    • yes, you can do that. do you have the spreadsheet created yet? if

      not, that would be your 1st step.

      choose Insert, Worksheet from the toolbar to add enough worksheets for

      all your employees. design your form & copy & paste it to all your

      sheets.

      susan

      Mrs. Happy! wrote:

      > I have Microsoft Office Excel 2003. I'm not very familiar with the program

      > and I need to set up of form to track individual employee's leave time. My

      > hopes is to have a sheet for each employee, be able to input a date, hours

      > requested and type of leave time (sick, vacation, or funeral) and have the

      > form figure the time that particular employee has left of each type of leave.

      > Is this possible?

      #1; Fri, 23 May 2008 02:15:00 GMT
    • Yes, it is possible.

      I would suggest laying out how you want it to look on the sheets first.

      IE, cell A1 is Employee name. Then A3 through A## is the date, B3

      through B## is Hours off, C is type of leave, etc. You can then look

      into User forms for inputting the data if you want to do that.

      Also, are you sure you want a sheet for each employee? I would

      probably contain it all on one sheet and just put the employee's name

      as one of the columns. You can then use autofilter when you want to

      look at just John Doe's leave, etc. You can then use a second sheet to

      hold the data for like how much vacation, leave, sick, etc time each

      employee has for the given year.

      Hope this helps.

      Mrs. Happy! wrote:

      > I have Microsoft Office Excel 2003. I'm not very familiar with the program

      > and I need to set up of form to track individual employee's leave time. My

      > hopes is to have a sheet for each employee, be able to input a date, hours

      > requested and type of leave time (sick, vacation, or funeral) and have the

      > form figure the time that particular employee has left of each type of leave.

      > Is this possible?

      #2; Fri, 23 May 2008 02:16:00 GMT