Can anyone explain to me how to correct the following logical expression
which is designed to compare two columns. If the first column contains a
1 (indicating PM time) and if the second column contains an integer less
then 12(after 12 noon) I want to add 12 to the number from the second
column. This is used to create a 24 hour clock column so that 1:00PM is
13 and 2:00PM is 14.

I31 contains either 0 or 1 (0=AM, 1=PM)
J31 contains hours 0-12

if J31 is 1 then it is a PM hour.

=IF(((I31="1") AND (J31<12)),J31+12,J31)

The problem is that it doesn't like the AND logical expression.


--
AceWebmaster
------------------------------------------------------------------------
AceWebmaster's Profile: http://www.excelforum.com/member.php...o&userid=30912
View this thread: http://www.excelforum.com/showthread...hreadid=505895

=IF(AND(I31=1,J31<=12),J31+12,J31)

"AceWebmaster" wrote:


Can anyone explain to me how to correct the following logical expression
which is designed to compare two columns. If the first column contains a
1 (indicating PM time) and if the second column contains an integer less
then 12(after 12 noon) I want to add 12 to the number from the second
column. This is used to create a 24 hour clock column so that 1:00PM is
13 and 2:00PM is 14.

I31 contains either 0 or 1 (0=AM, 1=PM)
J31 contains hours 0-12

if J31 is 1 then it is a PM hour.

=IF(((I31="1") AND (J31<12)),J31+12,J31)

The problem is that it doesn't like the AND logical expression.


--
AceWebmaster
------------------------------------------------------------------------
AceWebmaster's Profile: http://www.excelforum.com/member.php...o&userid=30912
View this thread: http://www.excelforum.com/showthread...hreadid=505895

I think J31 must contain numbers from 0 to 11, not to 12, in which case
the AND is not really required:

=IF(AND(I31=1,J31<=12),J31+12,J31)

can be replaced with:

=IF(I31=1,J31+12,J31)

Hope this helps.

Pete

try

=J31+I31*12


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=505895

Thanks everyone. The AND logic syntax had me baffled but now I
understand the syntax. The expressions worked great. The MOD also
worked great. I appreciate everyones help on resolving this.


--
AceWebmaster
------------------------------------------------------------------------
AceWebmaster's Profile: http://www.excelforum.com/member.php...o&userid=30912
View this thread: http://www.excelforum.com/showthread...hreadid=505895