Hi All, what is the custom time format for '11:21:00 PM' ? custom time format for 23:21:00 is HHss, and is working fine, but hhss should work for 11:21:00 PM but not working> please suggest.
Page 1 / 1
Hi @Vijay Gupta ,
- 'h' or 'H': Enables you to specify an hour as 'hh' or 'HH'.
- HH is a 24-hour time format and hh is a 12-hour time format with AM or PM.
Thanks!
Hi,
Thanks for your reply, But it's not working.. I tried it already...
Hi @Vijay Gupta
Try adding a at the back of the format.
The a will show the AM or PM at the back of the time.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.