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 27, 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.

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Aug 27, 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.

Resources