Separate/Split Date and Time using text formula.
Suppose you want to bring Date and Time in separate cells.
Of course you can do it manually if data is less but in case of more data we need formula.
We are going to use Text formula for this.
It is a formula which converts value into specified format.
Formulas applied.
To get Date =TEXT(A2,"dd/mm/yyyy")
To get Time =TEXT(A2,"hh:mm:ss")
Show only Month and Year =TEXT(A3,"mm-yyyy")
Make Date Time unique number =TEXT(A3,"ddmmyyyyHhmmss")
======================================
-Click below link to subscribe channel and stay tuned with latest uploads.
/ @learnyouandme
-Channel link
/ @learnyouandme
If liked this video then please subscribe,like and don't forget to click bell icon.
Make comment about your views, any suggestion or video topic you like to see.
Watch video Separate/Split Date and Time using text formula. online without registration, duration hours minute second in high quality. This video was added by user LearnYouAndMe 15 August 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7 once and liked it people.