Step 2Ĭonvert the minutes into decimal format-instead of minutes out of 60, make them percentages of 100. In a 24-hour time span, the hours past 12 p.m. Step 1Ĭonvert an employee’s start and end hours for the day, as well as any unpaid break time, to 24-hour time, also known as military time.įor example, your employee began working at 9:22 a.m., took a lunch break from 12:30-1:15 p.m., and ended their day at 5:08 p.m. Manually tracking employee hours by hand is an old method, but it works.
#Calculate timesheet with lunch how to
How to do the math for time cards by hand Then we’ll show you how time and attendance software can address those issues and make the entire process a breeze. Once you understand how to do manual time card calculations, it’s also important to know what problems you may face with that method, such as how much time it takes and how easy it can be for employees to commit time theft. That way, even with a computer, you’ll be able to spot and correct any inevitable errors. Even more established businesses that are using Excel spreadsheets, timesheet calculators, or other time tracking methods for calculating hours should know how the math works. New small business owners may find that calculating time cards manually works well for them initially, especially if they have a small number of hourly employees and few work hours to track. Not only does it ensure you’re paying your employees the right amount, but it also helps you make sure you’re not scheduling anyone for too many or too few hours, and it allows you to understand what staffing levels your business needs to function at its best. Calculating your employees’ time cards accurately is crucial to your business.