1. I would like to display a datetime format with AM or PM. I have tried with hh:mm:ss tt or hh:mm tt or hh:mm zz but it didn't work, it just display the time as 09:00 tt or 09:30 zz. Please give me some advice to address my problem.

It must be like this 01:30 PM or 09:00:30 AM

  1. Besides with that current format, I am not sure that it is correct or not. I tried to update some documents at 09:00 AM but it displayed at 01:00...


2 Answers 2


Try adding "... AM/PM") to the end of your formula:

=TEXT([Modified],"h:mm AM/PM")

See Stuart's answer here: Calculated field Date formula


For displaying required time format use "t" instead of "tt" Refer here : https://msdn.microsoft.com/en-us/library/az4se3k1(v=vs.110).aspx

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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