Solved

Combine Date field and Time field

Posted on 2013-06-21
4
393 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
ID: 39267300
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
ID: 39267307
Still didn't work unfortunately.
excel1a.JPG
excel1b.JPG
0
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39267398
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
ID: 39267410
Thanks, that did the trick.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

821 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