Solved

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

Posted on 2016-07-19
2
33 Views
Last Modified: 2016-07-19
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
Comment
Question by:jamesmetcalf74
2 Comments
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 41719922
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
 

Author Closing Comment

by:jamesmetcalf74
ID: 41719961
worked like a charm
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
excel pivot question 4 40
macro for same location path 2 19
How to move the last 4 digits of a number to a new column 8 42
NEED TO UPDATE DATA IN EXCEL 18 27
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now