jeff4smith
New Member
 Joined
 Jan 4, 2021
 Messages
 5
 Office Version

 365
 Platform

 Windows
I'm trying to determine the minimum, maximum, and average blood pressure readings from data exported from a blood pressure machine. The data includes a datetime value, and I would like to calculate different average, max and min values for morning and evening readings.
I would like to use a criteria in the MINIFS formula to determine if the time from a column of datetime values is before noon. I know I could create another column with only the time, but I'm using an imported data set which I do not want to manipulate as it will be refreshed, so I am hoping to have excel evaluate whether the time is before noon from the datetime value only.
I was able to create a similar formula based on the date below to grab the last 30 days, but I cannot figure out how to evaluate based on the time only and would like to add a second condition to this formula to only include values before noon.
=MINIFS(BloodPressure_data[Systolic],BloodPressure_data[Date Time],">="&TODAY()30)
I would like to use a criteria in the MINIFS formula to determine if the time from a column of datetime values is before noon. I know I could create another column with only the time, but I'm using an imported data set which I do not want to manipulate as it will be refreshed, so I am hoping to have excel evaluate whether the time is before noon from the datetime value only.
I was able to create a similar formula based on the date below to grab the last 30 days, but I cannot figure out how to evaluate based on the time only and would like to add a second condition to this formula to only include values before noon.
=MINIFS(BloodPressure_data[Systolic],BloodPressure_data[Date Time],">="&TODAY()30)