+ Reply to Thread
Results 1 to 4 of 4

Excel Formula for determining overtime hours, night diff.-OT hours, night diff. hours

  1. #1
    Registered User
    Join Date
    06-08-2014
    Posts
    2

    Post Excel Formula for determining overtime hours, night diff.-OT hours, night diff. hours

    Hi!

    I am working out a new payroll file for a construction company using excel and I can't figure out the formulas needed for determining the OT hours, ND-OT hours, and ND hours under the following situations:

    Time-in Time-out
    Day Shift : Employee1 = 8:00 am - 2:00 am
    Night Shift: Employee2 = 8:00 pm - 7:00 am


    **Day shift:
    Reg. time = 8am to 5pm
    Night diff. hours = 10pm to 6am
    Break hours = 12noon to 1 pm; 7 pm to 8pm

    **Night shift:
    Reg. time = 8pm to 5am
    Night diff. hours = 10pm to 6am
    Break hours = 1am to 2 am


    I hope to accomplish this as soon as possible with your assistance.

    THANK YOU!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,797

    Re: Excel Formula for determining overtime hours, night diff.-OT hours, night diff. hours

    HAve you used search function of forum http://www.excelforum.com/search.php
    See for instance some results:
    http://www.excelforum.com/excel-form...ay-period.html
    http://www.excelforum.com/excel-gene...t-and-end.html
    http://www.excelforum.com/excel-form...ing-excel.html
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    06-08-2014
    Posts
    2

    Re: Excel Formula for determining overtime hours, night diff.-OT hours, night diff. hours

    Hi Kaper.

    Thanks for your response.

    I have checked the links you provided, tried my best to use them but still i wasn't able to figure out the formula applicable to my timesheet.


  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,797

    Re: Excel Formula for determining overtime hours, night diff.-OT hours, night diff. hours

    Hi,
    May be try to prepare sample file with sample input and "manually calculated" expected output.
    Make sure input data is correct - to avoid such problems (may be I a, wrong, but I think it is a mistake) as:
    Day Shift : Employee1 = 8:00 am - 2:00am

+ 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. Working Hours between 2 dates (including Saturdays with Diff hours)
    By ejou11 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 07:39 AM
  2. Replies: 4
    Last Post: 09-21-2012, 12:58 AM
  3. [SOLVED] Calculation of Night Allowance between specific hours using excel
    By Womble2011 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-04-2012, 03:49 AM
  4. Replies: 2
    Last Post: 08-30-2012, 07:49 AM
  5. finding night hours (0-day,1-night) between ranges of data
    By sensation in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2012, 09:08 AM

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