Military Time

[Steved]

Hello from Steved excel 2000

Military time is 1400 in cell A1 in cell B1 I want to put
the text P because it is greater than 1200, and it
explains that it is Afternoon, but if it is less than
1159 I want the text to be A and in this case it is still
Morning

1200 = P

< 1159 = A

How do I right this as a Function Please.

Thankyou.

 

[Harlan Grove]

< 1159 = A

How do I right this as a Function Please.

Very little way you could write this wrong.

=IF(A1>=1200,"P","A")

 

[Max]

If time in col A is in hh:mm format,
e.g.: 12:00, 11:59, 02:00, 0:00 etc

try: =IF(A1<TIMEVALUE("12:00"),"A","P")

If time in col A is simply expressed as numbers
e.g.: 1200, 1159, 0200, 0000 etc

(with col A custom formatted as: 0000
to show leading zeros)

try: =IF(A1<1200,"A","P")

 

[Steved]

Thankyou Folks.

-----Original Message-----
Hello from Steved excel 2000

Military time is 1400 in cell A1 in cell B1 I want to put
the text P because it is greater than 1200, and it
explains that it is Afternoon, but if it is less than
1159 I want the text to be A and in this case it is still
Morning

< 1159 = A

How do I right this as a Function Please.

Thankyou.
.

 

[Max]

Pleasure' Steved !