even, odd time

[Tom F]

Does anyone know of a useful technique to tell if a cell contains an even time or an odd time?

Many thanks,
Tom F

 

[IML]

Is this determined by the hour or minute?

With a time in A1,
=CHOOSE((MOD(HOUR(A1),2)=0)+1,"odd hour","even hour")

should work based on the hour.

 

[Tom F]

This is based on the minute.

Tom F

 

[IML]

On 2002-10-22 10:48, Tom F wrote:
This is based on the minute.

Tom F

adjust to

=CHOOSE((MOD(MINUTE(A1),2)=0)+1,"odd","even")
or the shorter
=IF(MOD(MINUTE(A1),2),"odd","even")

 

[Mark W.]

=IF(MOD(MINUTE(A1),2),"odd","even")

Or, if you have the Analysis ToolPak installed...

=IF(ISEVEN(MINUTE(A1)),"even","odd")
This message was edited by Mark W. on 2002-10-22 11:54