Feb 20 2020 03:54 AM
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 times.
Column A is for time (HH:mm) and B-F are measurement values. I have always calculated averages manually in each time frame, but now I want to make a tool where I can just import the data and set time criteria. For example, if the data is recorded from 08:00 to 16:00, and I want to know the average at 12:00-12:30. What function to use to add a value into average calculation if time is greater or equal to start time (12:00) and lower or equal than end time (12:30).
Sorry for confusing question and thanks for any help!
Feb 20 2020 05:34 AM
Feb 25 2020 12:35 AM - edited Feb 25 2020 12:46 AM
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.
Feb 25 2020 01:03 AM
Feb 25 2020 01:57 AM
Feb 25 2020 03:09 AM
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!
Feb 25 2020 04:33 AM