Obscure Index/Match/formatting problem

[Ride The Lightning]

Hi

I have the following formula:
=INDEX('bet log 27.8'!$E$2:$E$1000,MATCH(A2,'bet log 27.8'!$B$2:$B$1000,0))

The data for 'bet log 27.8'!$E$2:$E$1000 is made up of "lay" and "back", the data for 'bet log 27.8'!$B$2:$B$1000 is a time in the following format: hh:mm:ss. The Value in A2 is also a time in the same format: hh:mm:ss. The answer I am getting is N/A. The formatting is the same and the formula is correct as I have already tested it on other sheets. The wierd thing is when I copy and paste the relevent time from 'bet log 27.8'!$B$2:$B$1000 to A2 the formula returns the correct answer! I would have thought this meant a formatting issue but they are the same! I am stumped as to why this is happening, any answers much appreciated.

Regards

RTL

 

[Aladin Akyurek]

Manged to totally fix it using MROUND, thanks to everyone who posted, appreciated.

Great. Thanks for that MROUND feedback.