A late idea came to my mind: if you temporarily format the cells like
hh:mm:ss then seconds not equaling zero would at once point to the rounding
issue.

Thanks for the feedback!
Stefi


€žsaltnsnails€� ezt Ã*rta:

I have it figured out. It did return the correct value on certain time
frames but not on others. I think it was b/c of the rounding issue. Some of
the figures came back 30.0000000000001000 etc when I expanded the decimals.
Thanks!
--
-CRM


"Stefi" wrote:

I tested your example and =if(c7=30, 0, 1) gave 0 for me (in Excel 2003).

You might check again your data and formats.

Stefi

€žsaltnsnails€� ezt Ã*rta:

My formula to calculate time in cell C7 looks like this:
=IF(B70,(B7-A7)*1440,0)

A7 and B7 are formatted for am/pm time. C7 is formatted for number. I
have 9:00 am in A7 and 9:30 am in B7. It calculates 30. When I ask the if
statement to return a 0 when the statement is true, it returns it as false
instead with a 1.

Hope that makes sense.
--
-CRM


"David Biddulph" wrote:

Is the C7 cell calculating a number of minutes, or is it a time in Excel
format? What is your formula, and what are the input values to the formula?

What value do you see in C7 if you temporarily change the format from time
to General or Number?

Also, are you sure that the time calculated is exactly 30 minutes, or might
it be 29.9999999 or 30.000001? You may wish to include a ROUND function in
your criterion.
--
David Biddulph


"saltnsnails" wrote in message
...
Stefi,
Thanks for the reply. I inputed that formula but it is still returning a
1
when the calculated time cell equals 30.
--
-CRM


"Stefi" wrote:

Try
=IF(MINUTE(C7)=30,0,1)

Regards,
Stefi

"saltnsnails" ezt Ã*rta:

I have a formula that calculates time. It works well. I am trying to
have
another formula return a value based on time calculated. If a cell
equals 30
minutes I want the formula to return a value of 0. If it does not
equal 30,
I would like a value of 1. So I have entered =if(c7=30, 0, 1). C7
refers to
the cell where the time is calculated. I entered time data and the
time
calculates a 30 but the other formula is returning a 1. Any thoughts?
--
-CRM