Why does the calculator say 19.5 hours for a shift that ran from 8 in the morning to 4 in the afternoon?

What the calculator actually did

You meant the shift to end at four in the afternoon. The time field received 04:00, which is four in the morning. There is no 'four o'clock' without a morning or evening attached: 04:00 is smaller than 08:00, and the fixed rule is that an end earlier than the start means the shift crossed midnight.

So it counts from 08:00 to midnight, 16 hours, then midnight to 04:00, four more, for 20:00. Take off the 30 minute break and you get 19:30, or 19.50 in decimal. The arithmetic is right for what was entered; the entry is what went wrong.

The badge that gives it away

Every row treated as an overnight shift carries a '+1 day' badge next to its hours, and below the result a line says 'Shifts ending the next day' with a count. If your staff only work days and that badge appears, one of the times went in on the wrong half of the clock. Check the badged row first.

The effect on pay is not small. At 25 SAR an hour, that single day comes to 487.50 SAR instead of 187.50 SAR. One field, 300 SAR of difference, which is why the badge deserves a glance before you download anything.

How to fix it

1. Open the Timesheet calculator and find the row with a '+1 day' badge that was not really a night shift.
2. Click the end time. If your browser shows a 12-hour picker, make sure the last part is set to PM, not AM.
3. Or think in 24-hour time from the start: four in the afternoon is 16:00, half past five in the evening is 17:30.
4. Check that the row now reads 7:30 and the badge is gone, then look at the total hours and pay again.

Why it calculates instead of warning you

Because 08:00 to 04:00 can be a real shift: a guard or a maintenance technician on a long rota works exactly that. The calculator does not know what your employee does, so it does not assume the figure is a mistake. It counts what you typed and adds the badge so you can decide. The only thing it refuses is an end time identical to the start, since that could mean zero hours or twenty-four.

A practical habit if you copy times from a handwritten attendance book: convert every afternoon time to the 24-hour clock before you enter it by adding 12 to the hour. One in the afternoon is 13:00, six in the evening is 18:00. That small step prevents most strange totals.