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

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

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

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

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

You are calculating a number of minutes, not a time, so you don't want to
use Stefi's suggestion of the MINUTE() function.
With your example values in those cells, the formula =IF(C7=30, 0, 1)
returns zero for me, so I guess you may have some rounding problems. You
didn't answer my questions.

What do you see in C7 if you format temporarily as number with 15 decimal
places? If you see anything different from 30.000000000000000 it may be
interesting to apply the same formatting to A7 and B7 and see if you see
0.375000000000000 and 0.395833333333333.

To tackle any rounding problems, what happens if you try =IF(ROUND(C7,0)=30,
0, 1) ?
--
David Biddulph


"saltnsnails" wrote in message
...
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

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

On Sep 24, 9:11*am, saltnsnails
wrote:
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- Hide quoted text -

- Show quoted text -

Well I am at a loss, as when I use your example with the columns
formatted
as you describe, it does resolve to True (0).

Format as Time Format as Time Format As Number Format As Number
=IF(B70,(B7-A7)*1440,0) =IF(C7=30,0,1)
9:00:00 AM 9:30:00 AM 30.00 0

You may have a flakey setting somewhere... check your settings for
things
like automatic vs manual calculations (toolsoptionscalcuations).

Try Exiting Excel... pasting into a new workbook etc.. what version
are you on?

On Sep 24, 8:52*am, "David Biddulph" <groups [at] biddulph.org.uk
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- Hide quoted text -

- Show quoted text -

My post isn't showing (google) so I've responded to a similar one;

Can you provide 2 samples? What is the column formatted as ? Any
chance it
was translated into text or something of that nature? try wrapping
quotes around
your values....

Try this

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




On Sep 24, 8:10*am, saltnsnails
wrote:
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- Hide quoted text -

- Show quoted text -

On Sep 24, 8:10*am, saltnsnails
wrote:
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- Hide quoted text -

- Show quoted text -

perhaps your formula does not resolve to an absolute value of 30?

Try rounding;

30.000158 0 =IF(B6=30,1,0)
30.000158 1 =IF(ROUND(B7,1)=30,1,0)

James, thanks for the reply. It still returns incorrectly. Maybe I need to
round the first calculation of time? How would I round this formula?:
=IF(B70,(B7-A7)*1440,0)
Thanks!
--
-CRM


" wrote:

On Sep 24, 8:10 am, saltnsnails
wrote:
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- Hide quoted text -

- Show quoted text -

perhaps your formula does not resolve to an absolute value of 30?

Try rounding;

30.000158 0 =IF(B6=30,1,0)
30.000158 1 =IF(ROUND(B7,1)=30,1,0)

You round a formula by putting Round in the formula, as in:
=IF(B70,round((B7-A7)*1440,0),0)

Regards,
Fred

"saltnsnails" wrote in message
...
James, thanks for the reply. It still returns incorrectly. Maybe I need
to
round the first calculation of time? How would I round this formula?:
=IF(B70,(B7-A7)*1440,0)
Thanks!
--
-CRM


" wrote:

On Sep 24, 8:10 am, saltnsnails
wrote:
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- Hide quoted text -

- Show quoted text -

perhaps your formula does not resolve to an absolute value of 30?

Try rounding;

30.000158 0 =IF(B6=30,1,0)
30.000158 1 =IF(ROUND(B7,1)=30,1,0)