+ Reply to Thread
Results 1 to 4 of 4

Accrue sick time by hour and Vacation time by day

  1. #1
    Registered User
    Join Date
    01-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    5

    Accrue sick time by hour and Vacation time by day

    Hello,

    I am VERY new to excel and need help to develop a spreadsheet that i can have for each of my employees.
    I need to be able to track accrued sick time by the hour, and accrued holiday time by days.
    Ideally it would show an entire year on a single sheet and I could choose which month goes first as I need to go by Anniversary.
    Accrual rate changes on anniversary dates as employees gain seniority.
    If anyone could help me develop something I would be very grateful!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,588

    Re: Accrue sick time by hour and Vacation time by day

    Were you able to download the file from the https://www.excelforum.com/excel-gen...ml#post5262262 thread?
    If so did the file contain what you need?
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    01-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Accrue sick time by hour and Vacation time by day

    I was, yes, thank you!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,588

    Re: Accrue sick time by hour and Vacation time by day

    You're Welcome and thank you for the feedback. Please take a moment to mark this thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. Using excel to track vacation/sick accruals and time taken
    By jmrlifesafe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2018, 09:59 AM
  2. [SOLVED] Timesheet vacation & sick time accrual
    By Dowjd in forum Excel General
    Replies: 2
    Last Post: 06-28-2015, 10:41 PM
  3. Formula for Calculating (Accrual) Vacation Time/ sick time
    By bsayers in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2014, 02:00 AM
  4. Non Accruing vacation/sick time
    By dzitoicihomes in forum Excel General
    Replies: 4
    Last Post: 06-27-2014, 02:02 PM
  5. 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
  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