Sweet, that got it thanks

"David Biddulph" wrote:

C3TIME(0,0,45).
You could also get away with C3--"0:00:45"
--
David Biddulph

"Brian" wrote in message
...
I'm trying to use a formula that if c3 is :45 seconds then etc....vlookup
the score that relates to that specific time