Saturday, May 27, 2017

yogi_Adjusting For Time In hh:mm:ss As Duration Using QUERY Function Versus Using FILTER Function

Google Spreadsheet   Post  #2170
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-27-2017
question by incolas:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/9jdwt0DDqlk;context-place=mydiscussions
When I use query on a duration, it shrinks the duration
Let's say the duration is 70 hours in the original data, when I query, I get 22 hours (which is 70-48).

And this is just one example; all queried durations get shrunk in the same way.

I unfortunately can't share the spreadsheet but I've seen very similar issues mentionned several times in the forums here, without answers...

Please help!