How to Calculate Hours Worked in an Week

Receiving the first paycheck from an hourly job may require you to figure how many hours you worked for the sum of money. The money earned in a week along with the hourly wage rate can be used to determine how many hours you actually worked. This is beneficial for people who work variable hours and only get paid for time worked.

Instructions

1. Take note of the gross pay on the paycheck. Gross pay is different from net pay. Gross pay is the total amount earned before tax deduction. If net pay is used, the calculation results will be invalid. Add the gross pay to one of the cells in the spreadsheet.

2. Write down the hourly wage. Hourly wage is important when calculating total hours worked. Hourly wage is usually applied only toward hourly employees and not people on flat-rate salaries. Add the hourly wage in a different cell in the spreadsheet.

3. Use the following formula in a separate spreadsheet cell to calculate the total hours worked:
   GrossPay/HourlyWage = TotalHoursPaid

   For instance, if the GrossPay was inserted into cell A1 on the spreadsheet and HourlyWage was inserted into cell B1, the following syntax is used to calculate the hours worked:
   =A1/B1

   Note the equal sign in the beginning of the statement. This tells the software that a formula should be calculated instead of using the actual text entered into the cell.