Technical Support Blog

How Is Time Converted?

Virtual TimeClock offers a lot of flexibility when it comes to employee timecards. You can decide what options to include on each report and how hours and overtime are sorted. You can even display total hours worked as decimal hours or hour & minutes. It's a small setting but it can make a big difference in how you interpret your employee timecards. The usual scenario goes something like this. You've added up the total hours column on a calculator and come up with a small difference to what's listed on the employee timecard. This is the result of converting time (hours & minutes) to decimal format. For example, :20 (20 minutes) is converted to .33 (20 divided by 60). If you add up :20 + :20 + :20 you get 1 hour. If you add up .33 + .33 + .33 you get .99 hours.

The conversion of time to decimal is based on the total hours & minutes so it's always 100% accurate rather than doing the decimal conversion on each entry and adding them up individually (which leads to the difference you're seeing). When you see timecard totals with a "." separator between the hours and minutes, it's in decimal format (which is based on units of 10 and how most payroll programs expect the hours). When you see timecard totals with a ":" separator, it's in hours & minutes format (which is based on units of 60).

Here's a little time conversion chart that may be helpful.