Day 79 · Wednesday, 21 October 2026

From the archive

Beginner

Round billable hours up to the next quarter hour with CEILING, then calculate the amount to bill

CEILING rounds a number up to the next multiple you choose, rather than to the nearest one, which is the rule most quarter-hour billing policies actually run on.

Task:

You invoice clients for an IT support contractor who logs time through a tracking app as a raw decimal — 7.38 hours, 6.12 hours, and so on. The services agreement bills in quarter-hour increments, rounded up in the firm's favor rather than to the nearest quarter hour. In column D, use CEILING to round each contractor's raw hours in column C up to the next 0.25. In column E, multiply the rounded hours by the hourly rate in column B to get the amount to bill. Fill in rows 2 through 6.

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

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