Solved

# Combine Date field and Time field

Posted on 2013-06-21
365 Views
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
Question by:PeterErhard
• 2

LVL 50

Expert Comment

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

Still didn't work unfortunately.
excel1a.JPG
excel1b.JPG
0

LVL 39

Accepted Solution

nutsch earned 500 total points
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

Thanks, that did the trick.
0

## Featured Post

### 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.

#### Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!