# Military Time

S

#### 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
< 1159 = A

How do I right this as a Function Please.

Thankyou.

H

#### Harlan Grove

Steved said:
< 1159 = A

How do I right this as a Function Please.
Very little way you could write this wrong.

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

M

#### 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

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

S

#### 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.
.