Bulletproof Sleep Calculator

The following method lets you handle all possible sleep spans inside of Notion. It has the advantage of letting you truthfully record the actual times, and auto-magically always gets the math right. Unlike the default formula that came with our Master Template, this formula lets you enter any combination of exact times from yesterday (Y) and/or today (T), plus naps, and calculates a correct total. Now you can enter sleep spans that are Y–Y (e.g., 1630–2330), Y–T (e.g., 2130–0530), and T–T (e.g., 0200 – 0900)— all without a hitch.

Safety first
Of course you can and should keep August’s formula and properties—no problem! Just make them invisible or scoot them to the right.

To create your Bulletproof Sleep Calculator, create the following properties:

  •  SleepOn (type NUMBER)
  •  SleepOff (type NUMBER)
  •  NapHours (type NUMBER)
  •  SleepSum (type FORMULA)

Here is the formula you paste into the SleepSum formula box:

prop("NapHours") + if(prop("SleepOn") < 0, if(prop("SleepOff") < 0, prop("SleepOn") - prop("SleepOff"), 24 + prop("SleepOn") + prop("SleepOff")), prop("SleepOff") - prop("SleepOn"))

Order your superior time-span properties as you like. My column order is: Sleep ∑ — SleepOn — SleepOff — NapHours

HOW IT WORKS

  • Use decimal versions of the 24-hour clock.
  • Use negative numbers for yesterday, and natural numbers for today.
  • Napping is allowed and encouraged. Took a 45 minute nap? Set NapHours to 0.75.

Examples

  • 11:30 AM yesterday is -11.5
  • 6:45 PM today is 18.75
  •  1:15 AM today is 1.25
  • 10:20 PM yesterday is 22.33

I am currently practicing Sleep Roam Tech—with great results. I sleep from 1400 – 2100, and so begin my day around 2230, magical creativity time for my excited inner tween. By 0300 I’m king of the night gaunts and already on fire. Up before the farmers!

I would enter this span as ⟨-14, -21⟩. Easy and meaningful, and done quickly. August’s ideal would be ⟨-21.5, 5.5⟩. Most people would be around ⟨0.5, 8⟩ or so.

Only in this way can you capture accurate sleep data. If you want to use some day as we further hybridize our souls with the reliable (classical-sized) machines, it’s in there.

Summary

  1. Enter your to-bed time in SleepOn
  2. Enter your wake-up time in SleepOff
  3. Enter total nap hours (from today only) to NapHours

Now your time data is meaningful and exact. And the calculation is right. And it includes naps.