Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 5th 19, 08:26 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2019
Posts: 2
Default 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   Report Post  
Old November 6th 19, 07:27 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2019
Posts: 2
Default attachment

attached zip file
Attached Files
File Type: zip Payroll example.zip (10.2 KB, 2 views)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA assistance needed G C Excel Programming 7 May 6th 16 02:19 PM
Excel 2003 VBA Assistance needed TymothΓ© Excel Programming 5 December 4th 08 02:17 PM
CODE Assistance needed PLEASE please please N.F[_2_] Excel Discussion (Misc queries) 0 July 9th 07 08:36 PM
VBA Assistance Needed RalphB Excel Discussion (Misc queries) 5 February 22nd 06 07:16 PM
Code assistance needed HJ Excel Programming 7 May 27th 05 04:14 PM


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017