Leave the cells under “Hourly Rate” blank.
In the rows below the named columns, enter the date, number of hours you’ve worked, and the amount you made. If you’re calculating the salaries of multiple employees, you can also include a column for “Employee Name” next to “Date.” Enter your hours and amount paid “Date” (Cell A4) > “# Of Hours Worked” (Cell B4) > “Amount Paid” (Cell C4) > “Hourly Rate” (Cell D4) The texts in your columns should look something like this: So, if you’re trying to stretch column “B”, you’ll want to click between “B” and “C” at the top of the spreadsheet and drag to adjust. You can change the width of the cell to fit longer words by moving your cursor between the top rows. Go to the top of the spreadsheet and start entering your information in each individual cell. You can also browse through this collection of Excel templates and download the one that best fits your style.
Open a new spreadsheet in Excel and add a title to your document so you can access it again in the future. Use these quick tips to calculate your salary in a matter of minutes: Open a new spreadsheet Make better decisions backed by data and insights Learn More How to set up your salary spreadsheetĭon’t get overwhelmed by the hundreds of different formula options, it only takes a few simple steps to calculate your hourly salary in Excel.
