Data entry and chart of blood sugar readings over time

[jjamjatra]

I want to enter blood sugar levels as a data series that can be plotted so my wife's doctor can see for an upcoming appointment. Her little book shows several readings per day. Here is a snippet from my practice workbook:

Date Time Level
1-Sep 08:00 109
1-Sep 12:00 149
1-Sep 16:00 125
1-Sep 22:00 115
2-Sep 08:00 135

I use a Form which allows me to enter 9/1 then 800 then 109, etc. On the one hand, I have lots of data to enter and I was trying to ease data entry by using military time and avoiding special characters. The format for values in my time column is custom 00\:00.

Yet I cannot get these values into a decent chart. I know this is a rookie question but I would appreciate guidance on the best way to accomplish this task.

 

[Hui]

You have to enter time as hh:mm or h:mm
eg: 8:00 is 8am, 15:00 is 3pm
the : is essential when entering the time even if the Custom Cell Format is different

The only other option is to enter '800 which will enter the 800 as text and then use a helper column to convert it to a time, but i'd just use the former method

 

[jjamjatra]

You have to enter time as hh:mm or h:mm
eg: 8:00 is 8am, 15:00 is 3pm
the : is essential when entering the time even if the Custom Cell Format is different

The only other option is to enter '800 which will enter the 800 as text and then use a helper column to convert it to a time, but i'd just use the former method

Thank you! I am brand new to this forum.