True / False Formula

D

Denise

I need a formula that will return a true or false. I have a column that has
the total elapsed time. I want a column that will return true if the elapsed
time is <=0:90 and false if it is > 0:90.

The formula I tried is
=AX2>=00:90

The results return false for everything. I am thinking that the colon in
the time is messing up the formula.

Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Change a great number of words in word files, with a macro as short as possible. 5
IF Statement Reading Zero's 2
Making a macro only work on certain files 2
Select Text to End of Footnote 9
VBA Export to PDF 0
Auto populate value from one task to another in MS PROJECT 0
Macro to Select text from a point given to a specific word 2

Top