Forum Discussion

melody1024's avatar
melody1024
Copper Contributor
Aug 26, 2019
Solved

Payroll Spreadsheet

I need to create a payroll spreadsheet that I can organize by day of the week, Thursday thru Wednesday with each employees name listed under each day, the column would be how many hours they worked t...
excel
Excel on Mac
Formulas and Functions
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Aug 26, 2019

    Hello melody1024 ,

     

    take a look at the attached file. It has a lookup table with people's names and their rates and a data entry table with columns for date, name, rate (which is looked up by a formula), hours and line total (which is calculated by multiplying hours with rate.

     

    You can enter new data in the immediate next row below the table (don't leave any gaps or blank rows) and then the formulas will automatically copy to the new row. 

     

    If you want to build a report for a certain time frame, there are several possibilities, i.e. filtering the data entry table, building a pivot table, using formulas, and more. 

     

    Get started with the data entry aspect and then tackle the reporting part.

nadhirathembavani's avatar
nadhirathembavani
Copper Contributor
Mar 24, 2026

You can structure it like this in Excel:

 

Columns: Employee | Hourly Rate | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Total Hours | Total Pay

Enter hours worked each day

Use a formula for total hours:

=SUM(C2:I2)

Calculate total pay:

=J2 * B2

Drag the formulas down for all employees.

If you want more automation, you can also add overtime rules using IF formulas.