SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a date field, and it has the date in the format - 11/2/2011 11:40 AM

How ever my requirement is to get the date in the format - 02 Nov 2011 11:40 AM

For that I created a calculated field for the said field and used the formula as - =TEXT(Modified,"dd mmm yyyy hh:mm ")

It resulted in the following date format - 02 Nov 2011 11:40 (It is a 24 hour format).

Now my question is how can I edit the formula to get the time in 12 hour format.

share|improve this question
up vote 6 down vote accepted

I believe the date/time format you are looking for is:

"dd mmm yyyy h:mm AM/PM"

This may be useful: TEXT function reference

share|improve this answer
Thank u :) Forgot AM/PM!! – Jithu Nov 2 '11 at 9:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.