Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

1 Answer 1

up vote 5 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
add comment

Your Answer

 
discard

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.