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
You can read more about this here:
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
