Time behaving strangely

[Tesnobay]

Hi, I upload a file of my blood pressure readings that includes the date and time the reading was taken. I was trying to group the entries by AM (6am-12: noon), PM (12:01pm-06:00pm) and Evening (6:01pm-11:59pm). I will also want to Average my readings during each of those time frames. I originally tried AVERAGEIFS, but then I realized the strange behavior.
Take 6:00 pm, when I applied conditional formatting to that time, it thought that it was a lesser value than 12:00 pm, I suppose because 6 is less than 12, but 6pm is a greater number or later time than 12 pm. I would think that military time would solve the issue, but this is starting to be higher than my pay grade. i don't have any reason for military time, and it seems like a wasted step to convert all those entries.

Any help or thoughts?

 

[StephenCrump]

It's not clear from your question whether you have date/time in the same cell, or in two different cells?

Or whether your dates/times are numeric, or text values?

If you just have the times stored as numbers, 6:00:00 PM (value 0.75) is greater than 12:00:00 PM (0.5).

 

[Tesnobay]

It's not clear from your question whether you have date/time in the same cell, or in two different cells?

Or whether your dates/times are numeric, or text values?

If you just have the times stored as numbers, 6:00:00 PM (value 0.75) is greater than 12:00:00 PM (0.5).

This is what it looks like. The time is formatted at time

 

[StephenCrump]

Take 6:00 pm, when I applied conditional formatting to that time, it thought that it was a lesser value than 12:00 pm

How are you applying the conditional formatting that shows 6:00 PM as less than 12:00 PM?

And what about the AVERAGEIFS that produce strange results?