How to calculate sleep debt from your bedtimes and wake times
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).
- Log bedtime and wake time each morning.
- Hours slept = MOD(wake − bed, 1) × 24.
- Nightly debt = goal − hours slept.
- 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)*24Good to know
A personal log, not medical advice.
Lullmoor Sleep & Energy Log: See what your best-rested days have in common
from $7Lullmoor ($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.