Gold Member Badge


  • You're all caught up!

How to Calculate Hours Worked for Employees

author image Dan Zisko
Based in California, Daniel Zisko has been a writer since 2008, penning articles for a variety of online publications. Before he started a writing career, he spent several years traveling and working as a hotel manager for several different hotel properties. Zisko holds a bachelor's degree in accounting from National University with a minor in biology.
How to Calculate Hours Worked for Employees
A close-up of a calculator, pen, money and a clock on a desk. Photo Credit: vetkit/iStock/Getty Images

All state governments and the federal government require businesses to keep accurate records concerning the number of hours employees work for paycheck calculations. Therefore, it is vital that the records you keep for your business are correct. Though you could spend money on an expensive time card system, its not necessary. It is entirely possible to calculate your hours with a simple spread sheet on a computer or sheet of paper.

Video of the Day

Step 1

Figure out which days will consist of your work week. Some companies will use a Sunday through Saturday work week. You could also use a Monday on Sunday. Look at your business levels and determine what works best for your company.

Step 2

Decide of the rules of your time keeping system. First, you need to determine how you will handle partial hours. For example, you might decide that all hours are to be broken down into four parts, meaning a person who works 15 minutes past the hour would work .25 hours. Then, you must decide how to calculate in exact punch times. For example, you may decide that a person who clocks in at 11:06 will be marked as starting at 11:00, but a person who clocks in at 11:07 will be marked as starting at 11:15.

Step 3

Write down or enter into a spreadsheet the actual time the employees clock in and clock out for their shift and lunch break. Make sure that the employee takes their lunch break according to the guidelines in your state.

Step 4

Round up or down all times according to your timekeeping. Write the rounded times in the employee's time sheet.

Step 5

Calculate the hours each employee worked from their initial clock in time to their lunch break. For example if an employee clocks in at 9:15 a.m. and goes to lunch at 2 p.m., their first working period for that day is 4.75 hours (9:15 a.m. to 1:15 p.m. is 4 hours and the 45 minutes to 2 p.m. is an additional .75 hours).

Step 6

Repeat Step 5 for the second period of the day, calculating hours from the time the employee comes back from lunch to the time they leave to go home. Using the same example, if an employee comes back from their lunch break at 3 p.m. and leaves at 5:30 p.m., their second period time worked is 2.50 hours (3 p.m. to 5 p.m. is two hours and then the 30 minutes to 5:30 is .50 hours).

Step 7

Add the numbers from the two periods together. In this example, the employee will have worked 7.25 hours (4.75 + 2.50 = 7.25). Add together the hours from all days they worked to get the sum of the hours they worked for that week.

LiveStrong Calorie Tracker
Lose Weight. Feel Great! Change your life with MyPlate by LIVESTRONG.COM
  • Gain 2 pounds per week
  • Gain 1.5 pounds per week
  • Gain 1 pound per week
  • Gain 0.5 pound per week
  • Maintain my current weight
  • Lose 0.5 pound per week
  • Lose 1 pound per week
  • Lose 1.5 pounds per week
  • Lose 2 pounds per week
  • Female
  • Male
ft. in.


Demand Media