In Excel, dates and times are stored as serial numbers. You can easily combine them by adding the two cells together to create a single datetime value.
Do it with AI insteadPrepare your data
Ensure your date is in one column and your time is in another column.
Enter the addition formula
In a new cell, type '=' followed by the date cell reference, a plus sign, and the time cell reference (e.g., =A2+B2).
Format the result
Select the cell, go to the 'Home' tab, click the 'Number Format' dropdown, and choose 'Custom' to set your preferred date and time display format.
=A2+B2Excel stores dates and times as numbers. You need to apply a date/time format to the cell to make it readable.