Thread
:
Average if between 2 diffrent times
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 18
Average if between 2 diffrent times
Worked like a charm thank you
On Friday, August 24, 2018 at 12:45:09 PM UTC-5, Claus Busch wrote:
Hi,
Am Fri, 24 Aug 2018 10:27:31 -0700 (PDT) schrieb
:
A B C D E
1 Seconds Times between and Answere avg.
2 150 8:11:59 8:00 AM 8:15 AM 275
3 400 8:09:40 8:15 AM 8:30 AM 400
4 200 8:18:01
5 600 8:30:00
try in E2:
=AVERAGEIFS($A$2:$A$10,$B$2:$B$10,""&C2,$B$2:$B$1 0,"<="&D2)
and copy down.
Regards
Claus B.
--
Windows10
Office 2016
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]