G Guest Nov 21, 2007 #1 I'm trying to use a formula that if c3 is >:45 seconds then etc....vlookup the score that relates to that specific time
I'm trying to use a formula that if c3 is >:45 seconds then etc....vlookup the score that relates to that specific time
G Guest Nov 21, 2007 #2 Brian said: I'm trying to use a formula that if c3 is >:45 seconds then etc....vlookup the score that relates to that specific time the problem is using the formula doesn't recognize the : format for time Click to expand...
Brian said: I'm trying to use a formula that if c3 is >:45 seconds then etc....vlookup the score that relates to that specific time the problem is using the formula doesn't recognize the : format for time Click to expand...
G Guest Nov 21, 2007 #4 Sweet, that got it thanks David Biddulph said: C3>TIME(0,0,45). You could also get away with C3>--"0:00:45" Click to expand...
Sweet, that got it thanks David Biddulph said: C3>TIME(0,0,45). You could also get away with C3>--"0:00:45" Click to expand...
