» Combining Data from Separate Columns into a Single Date and Time Value
Columns A:F contain values representing month, day, year, hours, minutes and seconds.
We want to combine the numbers from each row into a single date and time value.
Use the DATE and TIME functions as shown in the following formula:
Format the results (column G) as "mm/dd/yy hh:mm:ss".