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.
=======================================
Смотрите видео Date and Time format changing in Concatenate formula (Concatenate Date & Time) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь LearnYouAndMe 08 Сентябрь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 333 раз и оно понравилось 5 людям.