• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Convert Date Time in normal format

Hi,

I have a date in the format of 08-FEB-19 10.56.14.634000000 AM in cell A1 of my excel.What is the formula to use to get the time of the value in normal format. Kindly help me here.
 

bosco_yip

Excel Ninja
Or…....................

A1 : 08-FEB-19 10.56.14.634000000 AM

B1, enter formula :

=0+REPLACE(REPLACE(A1,FIND(".",A1),1,":"),FIND(".",A1,FIND(".",A1)+1),1,":")

Then, apply a Custom Number Format of dd-mmm-yy h:mm:ss AM/PM

or, h:mm:ss AM/PM

Regards
Bosco
 
Last edited:
Top