From the archive

Day 12

Saturday, 15 August 2026

Day 11Day 13
Intermediate

Pay a shift at the right rate, with the night premium on top

One formula, two lookups: what this person earns an hour, and whether tonight costs more.

Task:

You run payroll for a bakery that trades through the night. Five staff, each with a role and a shift, and a rate card in G1:H4 that pays by role rather than by person — night shifts earn the premium in H6 on top. Work out each person's pay in E2:E6, then total the payroll in E7. Write E2 so that copying it down the column just works.

The daily challenge is part of Pro

A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.

See what Pro includesBack to the latest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.