+ Reply to Thread
Results 1 to 3 of 3

Calculating Sick Leave (Absent but no pay)

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    Minnesota
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    12

    Calculating Sick Leave (Absent but no pay)

    We changed our policy to if any employee takes a sick day they must return to work with a doctors note. If no note no pay will be given. How do I change my sick leave formula to still subtract a day used with 0 hours sick? This post will not allow me to attach my timesheet to view so below is the formula I use. Thank You

    Example of May 2017 Sick Leave Formula (Note: Personals days are combined in with sick day formula)

    =+April2017!B5-(AJ5)/8-(AJ6/8)

    =April Sick Days remaining-(May total sick days used)/8 hrs. per day-(May total Personal days used)/8.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,179

    Re: Calculating Sick Leave (Absent but no pay)

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    10-22-2012
    Location
    Minnesota
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    12

    Re: Calculating Sick Leave (Absent but no pay)

    I have attached my workbook (hopefully it uploaded). I have included a Before worksheet (April), and After worksheet (May). Notes are in each worksheet.
    Attached Files Attached Files

+ 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. [SOLVED] Sick Leave Counting as an Instance
    By lcartwright in forum Excel General
    Replies: 3
    Last Post: 09-14-2016, 12:27 AM
  2. Annual Leave and Sick Leave fiel
    By lauphyon in forum Excel General
    Replies: 2
    Last Post: 06-24-2014, 05:00 AM
  3. Sick leave annual leave minutes spreadsheet
    By News12kim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-22-2013, 03:28 AM
  4. [SOLVED] Calculating Sick/Personal Leave
    By ssaurer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-25-2012, 08:54 AM
  5. staff leave and sick leave planner
    By Just granite in forum Excel General
    Replies: 1
    Last Post: 05-25-2012, 03:15 AM
  6. Replies: 1
    Last Post: 05-18-2011, 10:46 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