using time format in a formula

Brian · Nov 21, 2007

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

Brian · Nov 21, 2007

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

David Biddulph · Nov 21, 2007

C3>TIME(0,0,45).
You could also get away with C3>--"0:00:45"

Brian · Nov 21, 2007

Sweet, that got it thanks

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