+ Reply to Thread
Results 1 to 4 of 4

Employee Overtime Management

  1. 09-21-2013, 01:50 AM #1
    clkpd7
    clkpd7 is offline
    Registered User
    Join Date
    09-21-2013
    Location
    thailand
    MS-Off Ver
    Excel 2003
    Posts
    1

    Employee Overtime Management

    Hello,

    Kinda lost and without any good programing knowledge,

    I want to calculate Overtime for employee payable with different groups of staffs. Which means the

    Management group at on 8 hours shift and the pay rate for OT is at 1.75
    Workers group at on 10 hours shift and the pay rate for OT is at 2.0

    Cell B1 is the department
    Cell C1 is the Name of staff
    Cell D1 is the Date
    Cell E1 is the time In
    Cell E2 is the time out
    Cell G2 will be the total OT work
    Cell H2 will be the amount payable

    As you can see the data are continuously running with no blanks just that the time out will be below the time in I would like the formula to able to recongise the next staff is from different group based the name above the last count.

    Please help, will be camping here for solutions
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-21-2013, 03:12 AM #2
    AndyLitch
    AndyLitch is offline
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Employee Overtime Management

    It would be simpler to keep the calculation per record on a single line....... That way you can have a coherent table that maximises Excels' tools.

    See sheet 2 for an example.

    test1.xlsx
    Last edited by AndyLitch; 09-21-2013 at 03:37 AM.
    Elegant Simplicity............. Not Always
    Reply With QuoteRegister To Reply
  3. 09-21-2013, 03:18 AM #3
    SDCh
    SDCh is offline
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Employee Overtime Management

    I don't know how to count working hours, but may be with this you can handle your own problem
    or may be others can give you a better solution.
    Attached Files Attached Files
    Click (*) if you received helpful response.

    Regards,
    David
    Reply With QuoteRegister To Reply
  4. 09-21-2013, 03:27 AM #4
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Employee Overtime Management

    Pl see attached file.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 09-21-2013 at 04:08 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating overtime once employee has accumulated 40 hours.
    By shmwalla in forum Excel General
    Replies: 5
    Last Post: 06-13-2012, 01:51 AM
  2. Calculating total overtime hours worked per employee
    By markjmcl in forum Excel General
    Replies: 3
    Last Post: 09-07-2011, 06:49 PM
  3. employee timesheet with overtime
    By tatehebert1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2008, 11:53 PM
  4. Employee overtime payment
    By gomumy97 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-01-2007, 05:55 PM
  5. Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 12:36 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1