Hello. I have a problem with a spreadsheet here that I cannot figure out.
On the PayrollEntry sheet I've got a table with the following headers:
Date
Employee
Time In
Time Out
Advance
Total Shift Time hh:mm
Total Shift Time
On the left side of the table I've got a formula using =OFFSET(Sheet2!A:A,0,0,COUNTIF(Sheet2!$A:$A,">*"),1) to display a unique list of names of employees.
On the PayrollEntry sheet in cell A3 I have a date range dropdown box.
What I need is Column D2:D27 to populate with the sum of hours (decimal) worked for the date range in the dropdown box and in column E from E2:E27 to show the sum of any Payouts the employee took in that date range chosen in the dropdown box.
I have it working with VBA but it's super slow and really awful code. I'm wondering if its possible to do the same thing faster with excel formulas.
I've left data in that shows how I would like it to populate.
If possible I would like it to leave out total hours worked and total payouts if there are no employee names present to calculate those values from. Currently it produces zeros even though there are no employee names in column C.
Also if possible the dropdown list would display Feb_16 - Feb_29 if it is a leap year otherwise display Feb_16 - Feb_28.
I'm doing my best to help my mom with this so help would be absolutely amazing.
Bookmarks