4 columns with 4 parts of a date into one column with 1 date

jamesmetcalf74
jamesmetcalf74 used Ask the Experts™
on
Attached is a spreadsheet that has 5 columns
columns 1 through 4   have the following data

1 dateyear
2 datemonth
3 dateday
4 datetime

column 5 has an entry of a desired result deduced from the information in columns 1 - 4.  (i produced this by hand)

can i have a formula that will produce the result in column 5 from the information that is in columns 1 - 4?
experts-exchange.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use this formula in E2, and copy down.
=DATE(A2,B2,C2)+TIMEVALUE(LEFT(D2,LEN(D2)-4)&":"&MID(D2,LEN(D2)-3,2)&":"&RIGHT(D2,2))
experts-exchange.xlsx

Author

Commented:
worked like a charm

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial