Should I put Time in double quotes in Excel

[alipezu]

Hi All,
What Am I doing wrong here in this formula?? I want to match my Time "7:15" with Range A2:A5. Sould I put time in double quotes or should not use quotes for time.?? the Formula below gives me an error although 7:15 exists in the range.

A	B
7:15	=MATCH("7:15",(A2:A5)
8:15
15:45
9:30

<tbody>
</tbody>

 

[steve the fish]

This should work ok for you:

=MATCH("7:15"+0,A2:A5,0)

 

[jorismoerings]

Additional to Steve's suggestion:

Be aware the way: if you've formatted the cells containing timevalues as times; they could create a possible "not found" or "#N/A" caused by the difference in seconds or if there's a date in front which is not shown.