ExcelBanter - using time format in a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - using time format in a formula (https://www.excelbanter.com/excel-discussion-misc-queries/166839-using-time-format-formula.html)

Brian

using time format in a formula

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

using time format in a formula

"Brian" wrote:

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[_2_]

using time format in a formula

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

Brian

using time format in a formula

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

All times are GMT +1. The time now is 01:24 PM.