Weekly timesheet sample for tracking employee hours and calculating pay.

The image shows a weekly timesheet for an employee named John Doe, managed by Jane Doe, for the week starting November 1, 2021. The task is to verify the total hours worked, rate per hour, and total pay calculated on the timesheet.

---

🔍 Step-by-Step Breakdown:

#### 1. Understanding the Time Entries
Each day has two shifts:
- Morning shift: `Time In` → `Time Out`
- Afternoon shift: `Time In` → `Time Out`

We'll calculate the hours for each shift and sum them daily.

---

✔ Daily Calculations

| Date | Day | Morning Shift | Afternoon Shift | Total Hours |
|------------|-----------|---------------|------------------|-------------|
| 11/1/2021 | Monday | 8:00 AM – 11:00 AM = 3:00 | 1:00 PM – 5:00 PM = 4:00 | 7:00 |
| 11/2/2021 | Tuesday | 8:30 AM – 11:00 AM = 2:30 | 1:30 PM – 4:00 PM = 2:30 | 5:00 |
| 11/3/2021 | Wednesday | 8:21 AM – 11:00 AM = 2:39 | 1:00 PM – 4:30 PM = 3:30 | 6:09 |
| 11/4/2021 | Thursday | 8:00 AM – 10:45 AM = 2:45 | 1:00 PM – 7:00 PM = 6:00 | 8:45 |
| 11/5/2021 | Friday | 8:00 AM – 11:00 AM = 3:00 | 1:00 PM – 5:00 PM = 4:00 | 7:00 |
| 11/6/2021 | Saturday | 8:00 AM – 11:00 AM = 3:00 | (No afternoon shift) | 3:00 |
| 11/7/2021 | Sunday | (No shift) | (No shift) | 0:00 |

> ⚠️ Note: On Wednesday, morning shift from 8:21 AM to 11:00 AM is 2 hours 39 minutes.
> On Thursday, morning shift is 2 hours 45 minutes.

---

📊 Summing Up Total Weekly Hours

Let’s add all the daily totals:

```
Monday: 7:00
Tuesday: 5:00
Wednesday: 6:09
Thursday: 8:45
Friday: 7:00
Saturday: 3:00
Sunday: 0:00
```

Now add them step by step:

1. Hours:
7 + 5 + 6 + 8 + 7 + 3 + 0 = 46 hours

2. Minutes:
0 + 0 + 9 + 45 + 0 + 0 + 0 = 54 minutes

✔ So total time worked = 46 hours 54 minutes → 46:54

But the sheet says 36:54 — this is incorrect.

Wait! Let's double-check the individual day totals in the sheet:

- Monday: 7:00 → correct (3 + 4)
- Tuesday: 5:00 → correct (2.5 + 2.5 = 5)
- Wednesday: 6:09 → correct (2:39 + 3:30 = 6:09)
- Thursday: 8:45 → correct (2:45 + 6:00 = 8:45)
- Friday: 7:00 → correct (3 + 4)
- Saturday: 3:00 → correct
- Sunday: 0:00 → correct

Now sum again:

```
7:00
+5:00 = 12:00
+6:09 = 18:09
+8:45 = 26:54
+7:00 = 33:54
+3:00 = 36:54
+0:00 = 36:54
```

✔ So Total Hours = 36:54 is correct.

Wait — but earlier I thought it was 46:54? That was a mistake.

Let me recheck the morning shifts:

- Monday: 8–11 AM = 3h → ✔
- Tuesday: 8:30–11:00 = 2.5h → ✔
- Wednesday: 8:21–11:00 = 2h 39m → ✔
- Thursday: 8:00–10:45 = 2h 45m → ✔
- Friday: 8:00–11:00 = 3h → ✔
- Saturday: 8:00–11:00 = 3h → ✔

Afternoon shifts:

- Monday: 1:00–5:00 PM = 4h → ✔
- Tuesday: 1:30–4:00 = 2.5h → ✔
- Wednesday: 1:00–4:30 = 3.5h → ✔
- Thursday: 1:00–7:00 = 6h → ✔
- Friday: 1:00–5:00 = 4h → ✔

Now let’s sum all actual hours:

| Day | Morning | Afternoon | Total |
|-----------|---------|-----------|-------|
| Mon | 3:00 | 4:00 | 7:00 |
| Tue | 2:30 | 2:30 | 5:00 |
| Wed | 2:39 | 3:30 | 6:09 |
| Thu | 2:45 | 6:00 | 8:45 |
| Fri | 3:00 | 4:00 | 7:00 |
| Sat | 3:00 | 0:00 | 3:00 |
| Sun | 0:00 | 0:00 | 0:00 |

Now total:

- Hours: 7+5+6+8+7+3+0 = 46 hours
- Minutes: 0+0+9+45+0+0+0 = 54 minutes

Wait — that gives 46:54, but the sheet says 36:54.

✘ There’s a discrepancy.

But looking at the sheet again:

- On Thursday, the morning shift is 8:00 AM – 10:45 AM → 2h 45m → ✔
- But the afternoon shift is 1:00 PM – 7:00 PM → 6h → ✔

So Thursday = 2:45 + 6:00 = 8:45 → matches.

But when we sum:

- Mon: 7:00
- Tue: 5:00 → total: 12:00
- Wed: 6:09 → total: 18:09
- Thu: 8:45 → total: 26:54
- Fri: 7:00 → total: 33:54
- Sat: 3:00 → total: 36:54

Ah! So the total is indeed 36:54.

But wait — how?

Let’s convert everything to minutes to avoid confusion.

---

✔ Convert All Times to Minutes

| Day | Morning (min) | Afternoon (min) | Total (min) |
|-----------|---------------|------------------|-------------|
| Mon | 8:00–11:00 → 3×60 = 180 | 1:00–5:00 → 4×60 = 240 | 420 |
| Tue | 8:30–11:00 → 2.5×60 = 150 | 1:30–4:00 → 2.5×60 = 150 | 300 |
| Wed | 8:21–11:00 → 2h39m = 159 min | 1:00–4:30 → 3.5×60 = 210 | 369 |
| Thu | 8:00–10:45 → 2h45m = 165 min | 1:00–7:00 → 6×60 = 360 | 525 |
| Fri | 8:00–11:00 → 180 | 1:00–5:00 → 240 | 420 |
| Sat | 8:00–11:00 → 180 | 0 | 180 |
| Sun | 0 | 0 | 0 |

Now sum all minutes:

```
Mon: 420
Tue: 300 → 720
Wed: 369 → 1089
Thu: 525 → 1614
Fri: 420 → 2034
Sat: 180 → 2214
Sun: 0 → 2214
```

Total minutes = 2214

Convert to hours:

- 2214 ÷ 60 = 36.9 hours
- 0.9 × 60 = 54 minutes

✔ So 36 hours 54 minutes → 36:54 → ✔️ Correct

Earlier mistake: I misread the morning shift on Thursday as 8:00–10:45 = 2:45 → yes, but then I incorrectly added the total across days.

So the total hours of 36:54 is correct.

---

💰 Calculate Total Pay

- Rate per hour: $15.00
- Total hours: 36.9 hours (since 36:54 = 36 + 54/60 = 36.9)

$$
\text{Total Pay} = 36.9 \times 15 = ?
$$

Calculate:

- 36 × 15 = 540
- 0.9 × 15 = 13.5
- Total = 540 + 13.5 = $553.50

✔ Matches the value shown.

---

✔ Final Answer

The timesheet is correct.

- Total Hours Worked: 36:54 (36.9 hours)
- Rate Per Hour: $15.00
- Total Pay: $553.50

✔️ All calculations are accurate.

---

🧾 Summary

| Item | Value |
|---------------------|-----------------|
| Employee | John Doe |
| Week Starting | 11/1/2021 |
| Total Hours | 36:54 (36.9 h) |
| Rate per Hour | $15.00 |
| Total Pay | $553.50 |

✔ The timesheet is properly filled and mathematically correct.