I pull data fine now with this formula, but limited to only pulling from 0:00-23:00 on one day, what do I need to be able to pull data between days, like 0400-0400?
=SUMIFS('Total Scans Data2'!$M$5:$M$724,'Total Scans Data2'!K5:K724,Z4,'Total Scans Data2'!$L$5:$L$724,">="&Z6,'Total Scans Data2'!$L$5:$L$724,"<"&TIME(HOUR(Z7),MINUTE(Z7)+15,0))
Bookmarks