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