As the title says I am working on a Timesheet “app”. What I am really trying to do is create a simple to use Sleep Training workbook for parents of infants. I would love some advice on how to best structure the docs. My traditional approach of creating a “log” of every event has been challenging and it is clear that this isn’t the right approach.
Looking at excellent examples from the templates:
It seems clear that instead of a row for every event (Example Sleep Session: Start Nap, Check, Asleep, Wake up, Asleep, Wake Up, End Nap) I should create a single row for each sleep session? The challenge I am having is that each session can have an indeterminate number of events.
Attached is an example of my current pure logs of events.
I need to be able to calculate duration of total sleep, which is measured by the sum of the periods between Asleep and Awake between “Start Nap” Or “Start Night Sleep” and “Out of Crib”.
Ben’s approach in the second example is really elegant. I am wondering how you would approach nearly the same example but essentially including the ability to take multiple “breaks” per day. Ideally with the ability to pause and resume from a single button which would allow calculation of awake to asleep in my use case.