+ Reply to Thread
Results 1 to 2 of 2

Using excel to track vacation/sick accruals and time taken

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    Blaine, mn
    MS-Off Ver
    2007
    Posts
    79

    Using excel to track vacation/sick accruals and time taken

    Is it possible to use excel to track Vacation/Sick accrued hours as well as Time Off?

    Looking to set this up:Policy.JPG

    I'd like to set it up where each time I open excel it would run the accruals based on the employees start date, or click a button where it would update. I'd also like to lock in the formulas once set up so that there isn't any accidental changes.

    Is it possible, and how difficult would it be to set up and maintain? I'm no pro at excel, but I do know how to get around and do a fair amount of functions. My company currently uses MyBiz, but the program is old and unstable so we are needing to move forward, but MyBiz wants annual fees for the program to work, and since I only use a tiny portion of their product to just track accruals and time off, it's not worth the money. I did find another program called Staff Files that looks like it will work and alot less expensive, but it got me to thinking if this can be done in excel.

    Thanks for your help in advance! I very much appreciate it!
    Jessica

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Using excel to track vacation/sick accruals and time taken

    Since you are somewhat good at Excel, please create a sample file with the format you'd like.
    Enter some fake data and indicate where you'd make manual entries and what the end result should look like.
    Post your questions or seek help for formulas if necessary. You'll get help much quicker.
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-06-2014, 08:12 PM
  2. OMG Trying to Calculate Vacation and Sick Time
    By tlgeiger in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-19-2013, 10:51 AM
  3. Replies: 16
    Last Post: 11-21-2012, 09:47 AM
  4. Vacation/Sick Leave accruals
    By Carisa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-27-2012, 09:47 PM
  5. Excel 2007 : Vacation Accruals:first time posting
    By maine32 in forum Excel General
    Replies: 0
    Last Post: 07-23-2010, 12:00 PM
  6. Calculating Vacation/Sick time
    By missmel159 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2008, 05:45 PM
  7. template to track sick and vacation time for a year
    By wjageler in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-21-2006, 02:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1