Time Card Calculator

A time card calculator adds up worked time and converts it into pay. On the first tab you enter a start time, an end time and the unpaid break in minutes, and it returns the hours worked both as a decimal and as hours and minutes. The second tab takes the hours for each of the seven days and splits the week into regular and overtime at whatever threshold and multiplier you set. Overnight shifts work because an end time earlier than the start rolls past midnight. Pay is gross pay, with no tax or deduction applied.