Taking averages of values based on time

[NielsDS]

Hi!

I am struggling to automatically obtain a certain value from my worksheet.

INFO: (File added as ZIP in attachments)
Column E in the excel file represents values measured approximately each 100ms (represented in column A).
I added column B to represent the run time in a TIME format.
Column C adds this TIME format to the real time the measurements started.


QUESTION:
For each 5 seconds that elapsed I would like to have an average value of all the measured values (of column E) that were registered in those 5 seconds for the entire file.
These values can be pasted underneath each other in column K with next to them the time of column C on which they took place (eg 11:13:21 , 11:13:26 , 11:13:31 , ...)

Looking forward to your comments!

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to create and attach a suitable sample workbook. There is no need for us to have to download and extract a massive workbook - please trim it down accordingly and post again. Thanks.

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

[NielsDS]

Done. Excuse me for the inconvenience!

[AliGW]

Please tell us where to find the 10-15 rows of manually mocked up result data.

[NielsDS]

Measurements start flowing at row 5542

[AliGW]

OK - but you have removed the workbook ...

You are not making this easy for your helpers.

[NielsDS]

Apologies, it should be back now!

[JeteMc]

Perhaps the following will do what you want.
Cell I3 is populated using: =MIN(C2:C8805)
Cells I4 and down are populated using: =SUM(I3,TIME(0,0,5))
Cells J3 and down are populated using: =AVERAGEIFS(E$3:E$8805,C$3:C$8805,">="&I3,C$3:C$8805,"<="&I4)
Let us know if you have any questions.

[NielsDS]

The solution you provided was exactly what I was looking for.
Thank you so much!

Title will be edited to [SOLVED].

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.