Opv
02-13-2020, 12:00 PM
The following formula, AVERAGEIFS(INDIRECT(B$2),DATESONLY,">="&TODAY()-$G848), provides the average based on the number of days specified in cell, $G848, where:
INDIRECT(B$2) represents a named range of data corresponding to size of the DATESONLY range.
DATESONLY represents the date and time for each entry in the format, "02/13/2020 9:30 AM".
$G848 represents the designated number of days for which the average is sought.
I am attempting to expand the formula to allow me to distinguish the average for AM vs PM hours. Is this possible without a help column which extracts the hour for each cell within the DATESONLY range?
INDIRECT(B$2) represents a named range of data corresponding to size of the DATESONLY range.
DATESONLY represents the date and time for each entry in the format, "02/13/2020 9:30 AM".
$G848 represents the designated number of days for which the average is sought.
I am attempting to expand the formula to allow me to distinguish the average for AM vs PM hours. Is this possible without a help column which extracts the hour for each cell within the DATESONLY range?