Query-Issue: Duration

11 views
Skip to first unread message

Pete Cineastic

unread,
Jun 22, 2017, 6:22:30 AM6/22/17
to Google Visualization API
Hi everybody,

I'm preparing a spreadsheet for our small film archive with the need to sort by different variables like title, country that are incluced as variables. The basic table comes via importrange.
 
=Query('Test'!A1:D;"select A,B,C,D where A <> '' and A contains """&B1&""" and B contains """&B2&""" and C contains """&B3&""" ")

This works pretty fine unless it comes up for duration in D, which is formated as 00:mm:ss (or at least readable) and the column is formated like that.
In cell B4, I have the same format (00:mm:ss).

and D format 00:mm:ss > """&B4&"""

I also did some variations on the brackets (D format 00:mm:ss) or changing the format ##:##:## and leaving it blank doesn't work, too.

where (D > """&B4&""")

Thanks for your hints and help in advance!
Pete
Reply all
Reply to author
Forward
0 new messages