ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Average if between 2 diffrent times (https://www.excelbanter.com/excel-worksheet-functions/454150-average-if-between-2-diffrent-times.html)

[email protected]

Average if between 2 diffrent times
 
Help
I need help.
I need the average between 8:00 AM - 8:15 A.M., 8:15 A.M. - 8:30 A.M. and so on in 15 Min intervals
Can someone please help me build a formula to compute and avg. between those times please. ty

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

Claus Busch

Average if between 2 diffrent times
 
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

[email protected]

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




All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com