I'm trying to use DGET() to match values across several sheets. If I try and match criteria that are times, it always fails. If I replace the criteria with words, it is successful. Here is an image as an example:The one that failed was trying to match the time of 7:00 AM and the one that worked is matching the words StuffStuff. If I do an IF statement between the two times, it is TRUE.How do I get DGET to work with times?
DGET is not successfully matching criteria in Time format
google spreadsheets;formulas
You can use it without =& like this:=DGET(F60:M61,Sat,{Start Time;F67})