Multiple BG Tests in SS

[TJ Penn]

How do I record multiple tests in a cell when I'm doing tests every 15 minutes? I can't seem to record more than one number per cell? (asked on the tech board but haven't received an answer) Thank you!

 

[Daphne and Aida]

I think you put the BG number and the time separated with comas, like this (random numbers)
89 +2, 93 +2.5, 101 +2.75

 

[Suzanne & Darcy]

You can type them into the cell but you have to manually color code the cell background color and sometimes the text as well. Right now I can’t remember if it’s the Alt key or the shift key that you press to insert a “hard return” to keep all the text on separate lines.

 

[Suzanne & Darcy]

When I get back home I can help more with the spreadsheet when I can sit in front of the computer.

 

[Suzanne & Darcy]

Daphne has the right idea about how you put in the times (+2.75 for example meaning 2 hours and 45 minutes after the shot.). I prefer to not let the text wrap by itself because it sometimes makes awkward breaks and doesn’t keep information together that should be together to make it easier to read.