Formula to Combine Date and Time in One Cell in Excel | Date and Time With AM/PM Format

In this Microsoft Excel video tutorial I explain how to combine date and time in a single cell. I also explain how to change the format of times to 12 hour AM/PM format.

00:00 Introduction
00:04 Date is in one column and time is in another
01:07 Manually entering date and time in a cell with 24 or 12 hour format
01:55 Shortcut keys for entering today's date and time in a single cell

#exceltips #exceltutorial

[hisham]

Sir, you're a genius, thank you,

SUBSCRIBED, LIKED, AND INSPIRED TO CREATE A VIDEO LIKE YOU !!!

[philipboakes]

Thanks for the info along with the shortcuts

[lynncalta]

Thank you so much! This is so helpful!