Date and Time format changing in Concatenate formula (Concatenate Date & Time)
Some time we may require to join or concatenate Date and Time while doing so in joined text date and time changes to number format which we don't want we want date and time part in Date and Time format only.
To solve this we need to apply Text formula on data and Time.
This text formula changes date and time to text then we can join these to get expected result with date and time.
Text(Date,"dd-mm-yyyy") for date
Text (Time,"hh:mm") for Time
=======================================
-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 Date and Time format changing in Concatenate formula (Concatenate Date & Time) online without registration, duration hours minute second in high quality. This video was added by user LearnYouAndMe 08 September 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 333 once and liked it 5 people.