How to Combine Date and Time in Excel (2 Easy Formulas)

In this video, I will show you how to combine date and time in Excel using two simple ways.

You can either simply add the date and time values and Excel will combine it and give you the result (it often picks up the formatting as well, but if you want to change, you can do that easily).

You can also use the CONCAT to the CONCATENATE formula to combine the DATE and TIME values. While the output of this method is a text string, it allows you to do a lot more customizations. For example, you can show dates in different formats, such as only the month name or month and year name, etc.

00:00 Intro
00:09 Combine Date and Time by Adding it
02:21 Combine Date and Time by using the CONCAT formula

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.

Also, I have made all of my Excel courses available for free. You can check these out using the below links:

[chsrinivas]

you are a excellent explainer. God bless you

[buddiephotographer]

Great explanation... Not something I use a lot personally.... Dates and times etc... But always useful to know your options

[IvanCortinas_ES]

Superb explanation. Thank you Sumit Bansal!!!

[wayneedmondson]

Hi Sumit. Great Date and Time examples! Thanks for sharing :)) Thumbs up!!

[ansh]

Bhaiya please ek suggestion dijiye....
Me excel ki two multiple worksheets par work kar raha hu..and dono worksheet me ek order number name se column common hai. Ab mujhe sheet1 wale column me jo duplicate value hai wo sheet2 se match karna hai aur colour highlight bhi karna hai conditional formatting se. Only sheet1ke ek column ko sheet2 ke ek column se duplicate value match karna hai with colour highlight. please is par koi video ho to share kariye. ya koi formula ho to batao.

[kamatchisankaravadivel]

If it is different language means English and Hindi is there how to highlight in conditional formatting

[hussainmeghani]

Is there any solution to vlookup from multiple value cell. Like A1 =25, A2=7|25, A3=0, A5=0|7|25..desired result B1, B2, B5 should be mark as positive match...pls guide

[purple]

Need help in multiple drop-down selection box (Customised) ! Can you help me plz ?! If yes ...then pls let me know how to contact you !

[vanacharlasaipavankumar]

Can't I use and symbol instead of concatenate
Still your explanation is amazing

[halimahmad]

I do exactly what you say but fail...why?