|  

» Combining Data from Separate Columns into a Single Date and Time Value

Problem:

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.

Solution:

Use the DATE and TIME functions as shown in the following formula:
=DATE(C2,A2,B2)+TIME(D2,E2,F2)
Format the results (column G) as "mm/dd/yy hh:mm:ss".


Rate This Tip
12 34 5
Rating: 4.14     Views: 19321
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments