Overtime Premium: In this method, the cashier's 52 hours would show on the first line at $9.50 per hour. This would be the "time" part of the time-and-a-half rate for those overtime hours.

How to Calculate Time Card Hours to Payroll. ... If you use the rounding up method, that's 2.5 hours at time-and-a-half pay. If your approach is more exact, it's 2.42 hours.

Setting up an Excel spreadsheet to calculate time worked. Follow these steps: In A1, enter Time In. In B1, enter Time Out. In C1, enter Hours Worked.