Date Formula Query (I'm stuck!)

  • Thread starter Thread starter rcurtis8
  • Start date Start date
R

rcurtis8

Thanks for looking at my post :)

I am stuck on an 'IF' formula. I am trying to make the formula
recognise if a cell is more than or equal to 10 hours. See cell
details below:

cell D41: 01/01/1900 10:10:00

cell F41: =IF(D41>="01/01/1900 10:00:00","TRUE","false")

Upon clicking 'Evaluate' (Tools / Formula Auditing / Evaluate
Formula), I get the following evaluation:

IF(1.42361111111111>="01/01/1099 10:00:00","TRUE,"false")

It would appear that the format in cell D41 is not recognised by the
format in cell F41.

Any ideas where I am going wrong?

Cheers, Rob
 
Thanks for looking at my post :)

I am stuck on an 'IF' formula. I am trying to make the formula
recognise if a cell is more than or equal to 10 hours. See cell
details below:

cell D41: 01/01/1900 10:10:00

cell F41: =IF(D41>="01/01/1900 10:00:00","TRUE","false")

Upon clicking 'Evaluate' (Tools / Formula Auditing / Evaluate
Formula), I get the following evaluation:

IF(1.42361111111111>="01/01/1099 10:00:00","TRUE,"false")

It would appear that the format in cell D41 is not recognised by the
format in cell F41.

Any ideas where I am going wrong?

Cheers, Rob
Click to expand...

Your formula tests a number (1.4236...) against a TEXT value - you
could use datevalue to convert that, but why make life so difficult

10 hours is 10/24 so

IF(D41>=10/24,"TRUE","false")

Oh, and if you REALLY want true and false to be returned

=D41>=10/24

will do that quite nicely on it's own!
 
Your formula tests a number (1.4236...) against a TEXT value - you
could use datevalue to convert that, but why make life so difficult

10 hours is 10/24 so

IF(D41>=10/24,"TRUE","false")

Oh, and if you REALLY want true and false to be returned

=D41>=10/24

will do that quite nicely on it's own!- Hide quoted text -

- Show quoted text -
Click to expand...

Hi Aidan,

Thanks a lot for the response. I made the change and am now getting a
true response. However, when I change D41 to 2 hours, I still get a
true response when onviously this should change to false.

Any ideas?

Cheers, Rob
 
I don't, but I would use this simpler formula

=D41>=TIME(10,0,0)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top