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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
6 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”!

  4. Chip says:

    Thank you so much. Helped me big time.

Leave a Reply

Your email address will not be published. Required fields are marked *

*