Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 40
  • Last Modified:

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

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
0
jamesmetcalf74
Asked:
jamesmetcalf74
1 Solution
 
Ejgil HedegaardCommented:
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
0
 
jamesmetcalf74Author Commented:
worked like a charm
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now