Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Array assistance needed
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 Last edited by The last Excel Novice : November 5th 19 at 08:43 PM |
#2
|
|||
|
|||
attachment
attached zip file
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA assistance needed | Excel Programming | |||
Excel 2003 VBA Assistance needed | Excel Programming | |||
CODE Assistance needed PLEASE please please | Excel Discussion (Misc queries) | |||
VBA Assistance Needed | Excel Discussion (Misc queries) | |||
Code assistance needed | Excel Programming |