Pokyny krok za krokem
Identify Your Hours and Minutes
Start by separating your total time into two distinct parts: the whole hours and the remaining minutes. For instance, if you worked 6 hours and 12 minutes, identify '6' as the hours and '12' as the minutes.
Convert Minutes to a Decimal
Take your minutes and divide them by 60. Using our example of 12 minutes: 12 ÷ 60 = 0.2. This decimal represents the fraction of the hour you worked.
Combine the Results
Add your whole hours to the decimal you just calculated. In this case, 6 + 0.2 = 6.2. You now have your total time expressed as 6.2 decimal hours.
Verify and Round
Check your math to ensure you haven't miscalculated. If you have a repeating decimal, round your result to the nearest hundredth (two decimal places) to keep your payroll records clean and consistent.
Understanding Decimal Hours
When tracking time for payroll or client billing, you will often find that time is recorded in hours and minutes (e.g., 2 hours and 30 minutes). However, most accounting software and payroll systems require time to be entered as a decimal (e.g., 2.5 hours). Converting time manually is a simple process once you understand the relationship between minutes and the base-60 system.
The Golden Rule
Because there are 60 minutes in an hour, you cannot simply use the minutes portion as a decimal. For example, 30 minutes is not 0.30 hours; it is 0.50 hours because 30 is half of 60. By dividing your minutes by 60, you convert them into a fraction of an hour.
The Formula
To calculate decimal hours, use this simple formula:
Decimal Hours = Hours + (Minutes ÷ 60)
Worked Example
Imagine you worked a shift of 4 hours and 45 minutes.
- Keep the whole number: 4.
- Divide the minutes by 60: 45 ÷ 60 = 0.75.
- Add them together: 4 + 0.75 = 4.75.
Your total time is 4.75 decimal hours.
Common Pitfalls to Avoid
- The 'Decimal Mistake': The most common error is assuming that 15 minutes is 0.15 hours. Always remember to divide by 60. 15 minutes is actually 0.25 hours (15/60).
- Rounding Errors: If your division results in a long string of numbers (like 10 minutes ÷ 60 = 0.16666...), round to two decimal places (0.17) unless your payroll system specifies otherwise.
- Mixing Units: Always ensure your starting time is strictly in hours and minutes before beginning the calculation.
When to Use a Calculator
While doing this by hand is excellent for double-checking your work or understanding the logic, using a digital calculator or an Excel spreadsheet is recommended for high-volume payroll processing. If you are calculating hours for an entire month, a formula in Excel like =A1/60 will save you time and prevent manual entry errors.