SOLVED
Home

Payroll Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-823500%22%20slang%3D%22en-US%22%3EPayroll%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823500%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20a%20payroll%20spreadsheet%20that%20I%20can%20organize%20by%20day%20of%20the%20week%2C%20Thursday%20thru%20Wednesday%20with%20each%20employees%20name%20listed%20under%20each%20day%2C%20the%20column%20would%20be%20how%20many%20hours%20they%20worked%20that%20day%2C%20and%20I%20would%20need%20the%20column%20to%20automatically%20multiply%20the%20number%20of%20hours%20by%20the%20hourly%20rate%20that%20each%20individual%20employee%20earns%2C%20I'm%20new%20to%20excel%2C%20please%20help.%20%26nbsp%3BI%20have%20attached%20the%20very%20basic%20version%20that%20I've%20been%20having%20to%20use%20in%20word%2C%20excel%20doing%20the%20calculations%20would%20be%20much%20faster%20and%20more%20accurate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-823500%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823843%22%20slang%3D%22en-US%22%3ERe%3A%20Payroll%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823843%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398643%22%20target%3D%22_blank%22%3E%40melody1024%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Etake%20a%20look%20at%20the%20attached%20file.%20It%20has%20a%20lookup%20table%20with%20people's%20names%20and%20their%20rates%20and%20a%20data%20entry%20table%20with%20columns%20for%20date%2C%20name%2C%20rate%20(which%20is%20looked%20up%20by%20a%20formula)%2C%20hours%20and%20line%20total%20(which%20is%20calculated%20by%20multiplying%20hours%20with%20rate.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20enter%20new%20data%20in%20the%20immediate%20next%20row%20below%20the%20table%20(don't%20leave%20any%20gaps%20or%20blank%20rows)%20and%20then%20the%20formulas%20will%20automatically%20copy%20to%20the%20new%20row.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20build%20a%20report%20for%20a%20certain%20time%20frame%2C%20there%20are%20several%20possibilities%2C%20i.e.%20filtering%20the%20data%20entry%20table%2C%20building%20a%20pivot%20table%2C%20using%20formulas%2C%20and%20more.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGet%20started%20with%20the%20data%20entry%20aspect%20and%20then%20tackle%20the%20reporting%20part.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823900%22%20slang%3D%22en-US%22%3ERe%3A%20Payroll%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823900%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20soooooooo%20much!!!!!%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
melody1024
New Contributor

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 that day, and I would need the column to automatically multiply the number of hours by the hourly rate that each individual employee earns, I'm new to excel, please help.  I have attached the very basic version that I've been having to use in word, excel doing the calculations would be much faster and more accurate.

 

Thanks so much !!!

2 Replies
Solution

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.

Thank you soooooooo much!!!!!

@Ingeborg Hawighorst 

Related Conversations