# Tom’s Tutorials For Excel: Verifying a Time as AM or PM

Tom’s Tutorials For Excel: Verifying a Time as AM or PM

Here’s how you can verify a cell’s time value as either morning (AM), or afternoon or evening (PM). This is useful if you encounter a cell whose formatting does not show the time itself, such as in the pictured example below.

The formula in cell B2 is `=IF(MOD(A2,1)>=0.5,"PM","AM")`.
The “`>0.5`” portion of the formula sets the condition of the half-day mark, that being 12:00 noon, which separates the AM and PM halves of the 24-hour day. ###### 7 comments on “Tom’s Tutorials For Excel: Verifying a Time as AM or PM”
1. Zafar Quaseem says:

Many Thanks

2. Richard says:

Thanks for this – an eloquent and simple solution!

3. Peter says:

…but 12:00:00 PM is then given as “AM”!

• Tom Urtis says:

Thanks. I just edited the page to show the formula as
` =IF(MOD(A2,1)>=0.5,"PM","AM")`

4. Chip says:

Thank you so much. Helped me big time.

• Tom Urtis says:

Thanks, Chip!

5. Syd Salmon says:

A more intuitive alternative is `=TIMEVALUE()`.

TIMEVALUE(00:00) = 0
TIMEVALUE(06:00) = 0.25
TIMEVALUE(12:00) = 0.5
TIMEVALUE(18:00) = 0.75

Therefore, =IF(TIMEVALUE(A1)>=0.5,”PM”,”AM”)