Build an Employee Timesheet

Turn start and end times into hours worked, a weekly total and overtime.

You will learn to

• Convert a time difference into hours
• Total the week
• Calculate overtime over 40 hours

How it works

Excel stores times as fractions of a day, so 6:00 PM minus 8:00 AM is 0.4167 days. Multiply by 24 to get hours: =(C2-B2)*24. Total the week with SUM, and calculate overtime above 40 hours with =MAX(0,D7-40), which never goes below zero.

=(C2-B2)*24