1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Excel Array assistance needed

    From The last Excel Novice@21:1/5 to All on Tue Nov 5 19:26:19 2019
    Can someone help me with an array to auto calculate a payroll sheet
    based on time and leave entered? I'm using Excel 2010.

    The attached spreadsheet shows the time/leave/shift type color coded to
    show where the sum of total hours for each should be recorded in the
    REG, HW, OT, CE, D2 or D3 columns.

    Any assistance you all can provide would be greatly appreciated.

    Below is the leave/shift type legend:
    CE � Comp time Earned
    HCE - Comp time Earned on Holiday
    HW � Holiday Worked
    HOT � Overtime Worked on Holiday
    S � Sick Time
    AL � Administrative Leave
    V � Vacation
    CT � Comp time Taken
    J � Jury Duty
    P � Personal Leave
    D2 � 2nd Shift
    D3 � 3rd Shift




    --
    The last Excel Novice

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From The last Excel Novice@21:1/5 to All on Wed Nov 6 18:27:21 2019
    attached zip file


    +-------------------------------------------------------------------+ |Filename: Payroll example.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=1064| +-------------------------------------------------------------------+



    --
    The last Excel Novice

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)