Everyday math & dates
Time Card Calculator
Fill in the days you worked and leave the rest blank. Add your hourly rate to see the pay, with overtime at time and a half after 40 hours.
Your result will appear here.
How it's calculated
Each day's hours are the out time minus the in time, minus the break. The week's hours above the overtime threshold are paid at the overtime rate. Some states, like California, also pay overtime after 8 hours in a day; this calculator only uses the weekly rule.
How to do it in Excel
With in times in B2:B8, out times in C2:C8 and break minutes in D2:D8:
=(MOD(C2-B2,1) - D2/1440)*24- Hours for one day. Fill down.
=MAX(0, SUM(E2:E8)-40)- Overtime hours for the week.