Closed Thread
Results 1 to 2 of 2

Help Please...!! How To Separate Regular & Overtime Hours From Total Monthly Hours

  1. #1
    Registered User
    Join Date
    06-29-2016
    Location
    khobar
    MS-Off Ver
    2007
    Posts
    12

    Question Help Please...!! How To Separate Regular & Overtime Hours From Total Monthly Hours

    Hi All,

    If I have Total House in A1 and I want B1 to show me Regular Hours and C1 To take out remaining Hours as Overtime and show me.

    here In my country we have OFF on Fridays but still Fridays are paid as regular Hours
    Regular working Hours are 8 and the above all is calculated as Overtime.
    Monthly Total Regular Hours are 248 (8x31=248)

    Suppose...
    If A1 is showing Total 288 Hours
    So B1 should show 248 but how???
    And C1 should show the remaining 40...

    I want to know the formula or anyhow needs that to be done for my work purpose.

    thanks in advance guys.

    regards,
    IFFY
    Last edited by iffyxalone; 06-29-2016 at 08:49 AM. Reason: spell mistake

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Help Please...!! How To Separate Regular & Overtime Hours From Total Monthly Hours

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-form...hly-hours.html

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 04-23-2016, 01:42 AM
  2. Regular hours until 40, then overtime
    By Wilmat13 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-11-2015, 03:32 PM
  3. Formula for separating overtime from regular hours.
    By BPemberton in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-24-2014, 11:24 AM
  4. Calculating regular/overtime hours
    By shawdowheart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-20-2014, 11:22 AM
  5. Formula to calculate regular hours and overtime hours
    By judojames in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2014, 05:30 PM
  6. Replies: 8
    Last Post: 03-19-2009, 11:01 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