Coda Noobie here.
I was building some databases and I took the decision to build these (Wake Up and Sleep) separated because makes sense for me (open for feedback):
I already tried using just one table (Like Sleep Tracking), but I couldn’t figure out how to get the hours slept. Simply because I probably should use the Sleep Time from one row and Wake Up Time from the subsequent row and do the math.
So, I intend to build this Sleep Tracking table using the values from the ones mentioned above and make a formula to get a value for hours slept. I will use these data to create some charts and hopefully understand some patterns.
Could you help me to do that?
Since right now I’m so grateful for any help!
Here is the doc: