Forum Discussion

Copper Contributor

Feb 20, 2020

How to count average in certain time range

Hello Excel wizards, I'm not the best with Excel so I would like to ask for help with this problem I have. I have 8 hours of measurement data and I want to know 30 minute averages in certain ...

excel

rutilusss

Copper Contributor

Feb 25, 2020

JKPieterse

Hi Jan,

Thanks for your help!

I used your formula but it returns #DIV/0!.

I tried to find an explanation for this but I can't get it work...

Any tips would be highly appreciated!

In that example I was trying to calculate it only for column B.

JKPieterse

Silver Contributor

Feb 25, 2020

What is in the cells in column A *precisely*? If you change their number format to general, what do they show?

rutilusss
Copper Contributor
Feb 25, 2020
JKPieterse

I changed it to general and now A3-A5 are:

43871.44392
43871.4441
43871.44427
- rutilusss
  Copper Contributor
  Feb 25, 2020
  rutilusss
  
  I got it now!
  
  Column A had actually YYYY/MM/DD HH:MM but only time was visible.
  
  Deleting the date fixed it. Thanks for your advices!
  - JKPieterse
    Silver Contributor
    Feb 25, 2020
    I figured as much, great you were able to solve the issue.