Finding record based on time-fields

Struggling with the switch to the SQL connector :)

I have a table with time-fields. Not date, not date-time, but only time.
I can generate a list of rows showing the different times in the database e.g. on a certain date
D7:=NL("Rows=2","Table","Starting time","Date","01-01-2015")Using the excel formatting to make them look like decent times works fine, so I end up with 9:15, 10:00, 21:15 etc in rows.
So far, so good.
But per Starting time are several records containing the person that will start on that time and that day.
So I try to generate a list of persons based on the found time.
E8:=NL("Rows","Table","PersonID","Starting time",E6,"Date","01-01-2015")To get the time on the correct row D6:=D7 and E6:=D6

In the NAV 2009 connector I had to format the found time to hours:minutes in D6:=Text(D7,"hh:mm") to make it work.
But with the SQL connector, no matter how I format the time, the result for E8 stays empty…
These are the formats I tried so far:
9:15
09:15
1754-01-01 09:15
1754-01-01 09:15:00
1754-01-01 09:15:00.000
2015-01-15 09:15:00.000
2015-01-15 09:15:00
2015-01-15 09:15
42019,3854166667
0,3854166667

1754-01-01 is used in SQL to 'say' that there is no date portion in this field.
2015-01-15 is shown in excel when a time field is formatted as date-time.
The last two are unformatted.

Nothing works.
What am I missing?

rmw