MrsGrayMarlin
New Member
- Joined
- Sep 16, 2024
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I am a payroll professional. I use an Excel spreadsheet to track regular/PTO/holiday, etc., hours to compare to our payroll processing software totals. I am using Microsoft® Excel® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 64-bit
For each employee, their line contains their regular bi-weekly hours (usually 80) in column L. Columns M, and N are titled "Hourly" and "Salary," respectively, depending on the employee's classification. Columns M or N contain the formula "=L69-O69-R69-S69-T69-U69-V69-W69-AA69-AF69-AG69” where “L” is their regular hours and all other columns represent Unpaid Time off (O), PTO Week 1 (R), PTO Week 2 (S), Holiday Week 1 (T), Holiday Week 2 (U), Floating Holiday Week 1 (V), Floating Holiday Week 2 (W), Jury Duty (AA), Bereavement Week 1 (AF), Bereavement Week 2 (AG).
I have a master template sheet at the beginning of the workbook. For each two-week pay period, I copy the template using right-click, move, or copy to a new sheet and name it with the pay period's dates. This issue occurs whether I follow that process or if I copy all data and paste it to a new worksheet.
When entering holiday or PTO hours into columns T or U, the formula in column M or N (again, depending on the employee classification) gets copied to the cell, which does not contain the data in column M or N. For example, if employee A occupies row 45, and is an hourly employee, their formula will reside in cell M45. Once I enter 8 hours to column T to indicate 8 hours of holiday pay, the formula will copy to cell N45. That means I have data in M45 and N45, which throws off my column totals.
Does anyone know why this might be happening? Please let me know if you need screenshots or any other information to assist me.
Thank you!
For each employee, their line contains their regular bi-weekly hours (usually 80) in column L. Columns M, and N are titled "Hourly" and "Salary," respectively, depending on the employee's classification. Columns M or N contain the formula "=L69-O69-R69-S69-T69-U69-V69-W69-AA69-AF69-AG69” where “L” is their regular hours and all other columns represent Unpaid Time off (O), PTO Week 1 (R), PTO Week 2 (S), Holiday Week 1 (T), Holiday Week 2 (U), Floating Holiday Week 1 (V), Floating Holiday Week 2 (W), Jury Duty (AA), Bereavement Week 1 (AF), Bereavement Week 2 (AG).
I have a master template sheet at the beginning of the workbook. For each two-week pay period, I copy the template using right-click, move, or copy to a new sheet and name it with the pay period's dates. This issue occurs whether I follow that process or if I copy all data and paste it to a new worksheet.
When entering holiday or PTO hours into columns T or U, the formula in column M or N (again, depending on the employee classification) gets copied to the cell, which does not contain the data in column M or N. For example, if employee A occupies row 45, and is an hourly employee, their formula will reside in cell M45. Once I enter 8 hours to column T to indicate 8 hours of holiday pay, the formula will copy to cell N45. That means I have data in M45 and N45, which throws off my column totals.
Does anyone know why this might be happening? Please let me know if you need screenshots or any other information to assist me.
Thank you!
