Thursday, May 14, 2015

Excel Formatting Date value

up vote127down voteaccepted
=TEXT(A1,"DD/MM/YYYY hh:mm:ss")
(24 hour time)
=TEXT(A1,"DD/MM/YYYY hh:mm:ss AM/PM")
(standard time)
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)