Skip to content
Search/
CyberMax › Answers

How to calculate sleep debt from your bedtimes and wake times

Updated 2026-11-18 · Planners and templates · by CyberMax

Short answer

Hours slept = wake time − bedtime, adding 24 hours when you went to bed before midnight. Sleep debt for a night = your goal − hours slept; add the nights for the week (negative values mean extra sleep).

  1. Log bedtime and wake time each morning.
  2. Hours slept = MOD(wake − bed, 1) × 24.
  3. Nightly debt = goal − hours slept.
  4. Weekly debt = sum of nightly debt.

Copy-paste code

Spreadsheet: hours slept from bedtime (B2) and wake time (C2), even past midnight

=MOD(C2-B2, 1)*24

Good to know

A personal log, not medical advice.

Lullmoor Sleep & Energy Log icon

Lullmoor Sleep & Energy Log: See what your best-rested days have in common

from $7

Lullmoor ($7) logs bedtime, wake time and how you feel in a minute each morning, and works out hours slept, sleep debt against your goal and bedtime patterns.

Secure checkout · 14-day fix-or-refund if it doesn't work as described (terms)

Free: the Free Planner Sampler

4 printable previews (budget, debt payoff, focus planner, habit tracker), then 5 short emails with formulas that make a budget stick.

You get one email to confirm first. Then the kit, and 5 short emails over two weeks. One-click unsubscribe in every email; we never share your address.