+ Reply to Thread
Results 1 to 2 of 2

PTO Calendar

  1. #1
    Registered User
    Join Date
    04-28-2011
    Location
    Oshkosh, Wi
    MS-Off Ver
    Excel 2007
    Posts
    30

    PTO Calendar

    Has anyone here ever created a Paid Time Off (PTO) calendar? I created a very simple one, but I'd like to get feedback, ideas or potentially, someone elses' completed product before I invest any time in this thing.

    I've attached an example.

    PTO in my company's case includes sick, holiday and vacation time in one "hour bank". Holidays are mandatory and usually known 10 months before the new calendar year starts. The accrual rate is a set number of hours every two weeks, it's higher based on employee years of service, and changes on the date of service anniversary.

    Our PTO system starts beginning of this year, a major problem is that there is no simple way to see how many hours you'll have on a certain date due to the accrual process. My calendar spreadsheet does this, but doesn't do anything dynamic.

    Also, sorry if this isn't in the right place, but it might require some programming to operate nicely.
    Attached Files Attached Files
    Last edited by CWinkler; 09-02-2011 at 02:45 PM.

  2. #2
    Registered User
    Join Date
    04-28-2011
    Location
    Oshkosh, Wi
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: PTO Calendar

    I see no one has replied, Bump up for visibility.

    Appreciate any feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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