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.

Highlighted

Thank you soooooooo much!!!!!

@Ingeborg Hawighorst 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies