+ Reply to Thread
Results 1 to 2 of 2

Semi monthly overtime tracker

  1. #1
    Registered User
    Join Date
    02-16-2017
    Location
    reno, nevada
    MS-Off Ver
    2003
    Posts
    2

    Semi monthly overtime tracker

    Hi there,

    I am new to this forum. I am looking for a spreadsheet to calculate overtime for our employees. I don't want to reinvent the wheel if I don't have to.

    I'm looking to create something that has the following criteria:

    Work week is Sunday to Saturday.*
    Pay periods run from 1st-15, and 15-end of the month.
    Overtime is based on more that 40 hours per week (Sunday to Saturday)
    Overtime is spread between paychecks based on how the pay period falls
    No need to enter in time, just total hours for the day
    PTO, Holiday, Sick time do not count towards overtime hours of 40+ per week.

    Thank you in advance for any help you can provide!

  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,005

    Re: Semi monthly overtime tracker

    Attach a sample workbook. 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"Reply" then GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Template for calculating overtime over time periods--semi monthly pay
    By smiley22124 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2017, 12:50 PM
  2. Semi-Monthly Formula
    By stephenvward in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-22-2015, 10:41 PM
  3. Overtime tracker
    By HRQ in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-12-2014, 04:33 AM
  4. Calculate overtime hours when Paying Semi-Monthly
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-06-2013, 12:14 PM
  5. Semi Monthly Dating
    By Mathalete in forum Excel General
    Replies: 7
    Last Post: 07-15-2011, 03:28 AM
  6. semi monthly date formula help please
    By tabegle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2011, 01:03 PM
  7. Time sheet Semi-monthly
    By kalagara27 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-05-2008, 09: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