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

Advertisements

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
to show leading zeros)

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

military time 9
Military Time 2
Military Time 1
Military time 6
Using military time 4
Military time trouble 7
converting military time 6
time calculation with military time 8

Top