Skip to main content
Web Applications

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

9
  • Try using =query(u24:v34, "Select Avg(V) where U <= timeofday '09:59:00'") Link to similar question webapps.stackexchange.com/questions/88774/… Commented Jan 28, 2021 at 13:43
  • @Oleg_S Thanks. I tried your suggestion and it returns a parse error. I changed the comma to a semi-colon (u24:v34;) due to locale and it returns the string avg to cell V40 and the number 8 to cell V41. However, that still won't select only records between times, will it? Commented Jan 28, 2021 at 14:47
  • @Oleg_S further analysis of the result figure 8 in V41 and what it represents is unclear.I have provided a link in the question to the sheet. Commented Jan 28, 2021 at 15:59
  • Still don't fully understand if Time in Column U is only for test1, or for all tests. Following is for assumption that time is one for all tests, in other case you'd need 2 more time columns. Added Copy of your Sheet. Commented Jan 29, 2021 at 8:53
  • @Oleg_S sorry, my bad explanation. The time in column U is for all tests. The 3 tests are part of the same event so at that time, 3 values are recorded. I've added a further clarification in the body of the question. Commented Jan 29, 2021 at 10:46