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

On 16 Aug, 11:17, rcurt...@gmail.com wrote:
> 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

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!

On 16 Aug, 11:30, "aidan.herit...@virgin.net"
<aidan.herit...@virgin.net> wrote:
> On 16 Aug, 11:17, rcurt...@gmail.com wrote:
>
>
>
>
>
> > 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
>
> 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 -

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)



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On 16 Aug, 11:30, "aidan.herit...@virgin.net"
> <aidan.herit...@virgin.net> wrote:
>> On 16 Aug, 11:17, rcurt...@gmail.com wrote:
>>
>>
>>
>>
>>
>> > 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
>>
>> 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 -
>
> 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
>
>