All Posts

Google Sheets Formula for Employee Hours Tracking

2026-03-18

Basic Hours Calculation

If clock-in is in column A and clock-out in column B (both formatted as time), this gives you decimal hours:

=(B2-A2)*24

Overtime Calculation

Calculate overtime (hours over 40 per week):

=MAX(0, SUM(C2:C6) - 40)

Regular vs. Overtime Pay

Where D2 is the hourly rate, calculate total pay with 1.5x overtime:

=IF(SUM(C2:C6)>40, 40*D2 + (SUM(C2:C6)-40)*D2*1.5, SUM(C2:C6)*D2)

Generate formulas instantly

Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.

Try FormulaWiz Free