Solved

Combine Date field and Time field

Posted on 2013-06-21
4
365 Views
Last Modified: 2013-06-21
I have a column with the date and a column with the time.

How can I combine these two fields into one? When I try I get the attached.
excel2.JPG
0
Comment
Question by:PeterErhard
  • 2
4 Comments
 
LVL 50

Expert Comment

by:barry houdini
Comment Utility
Don't concatenate, sum, i.e.

=B1+C1

format in required format like dd/mm/yyyy hh:mm:ss AM/PM

regards, barry
0
 

Author Comment

by:PeterErhard
Comment Utility
Still didn't work unfortunately.
excel1a.JPG
excel1b.JPG
0
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
Comment Utility
If it didn't work, one of your dates / time cells is a text value masquerading as a date. You can run a text to columns to do a mass conversion or you can use this uglier version of the formula:

=if(isnumber(b1),B1,datevalue(b1))+if(isnumber(C1),C1,datevalue(C1))

Thomas
0
 

Author Closing Comment

by:PeterErhard
Comment Utility
Thanks, that did the trick.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

728 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

14 Experts available now in Live!

Get 1:1 Help Now