To calculate time cards manually, gather all the information regarding the hours worked. Take the hours worked--from the period that employee clocked in until he clocked out--and subtract from this time for breaks and lunch. Keeping precise records of time worked is important for employees who are paid hourly.How do you calculate weekly time?
Divide the employee's total hours by the number of weeks in the measurement period. For an employee who worked 1,560 hours in a year, divide 1,560 by 52 to find the weekly average of 30 hours.How do you add up work hours?
To add up a single day's hours, insert a simple = SUM (B7+D7) formula into the "Total hours" cell at the end of the first work day (E7 in this example). Once an employee has typed in their hours in the "morning" and "afternoon" cells, they will be automatically added up in the "total" field.How do you calculate payroll time?
Add all of the hours for the week to obtain the total hours for weekly payroll. For example, two nine-hour days, eight hours and six hours in one week equals 32 hours for the week. 4. Multiply the hours worked by the hourly rate to determine gross pay.