Excel merge cell date and time

excel datetime ms-office
Pointer picture Pointer · Dec 15, 2016 · Viewed 37.4k times · Source

I want merge cell in Excel 2013 column date (2016-01-01) and column time (16:00:00),

How do I format cells to get 2016-01-01 16:00:00 ?

Here is my example https://postimg.org/image/clxeqb66h/

I get 42677 16:00:00

Answer

Ron Rosenfeld picture Ron Rosenfeld · Dec 15, 2016

  • ADD the two values

    • Dates and Times are stored in Excel as numbers of days since 1 Jan 1900 and fractions of a day for the time. So to combine a date and time you would add them

    • Format the result as yyyy-mm-dd hh:mm:ss

enter image description here

Related questions

Converting unix time into date-time via excel

Trying to convert 1504865618099.00 Unix time into a readable date time. I tried this: =(UNIX + ("1/1/1970"-"1/1/1900"+1)*86400) / 86400 But it's not working.

Read More
How to get the difference in minutes between two dates in Microsoft Excel?

I am doing some work in Excel and am running into a bit of a problem. The instruments I am working with save the date and the time of the measurements and I can read this data into Excel with …

Read More
Parsing an ISO8601 date/time (including TimeZone) in Excel

I need to parse an ISO8601 date/time format with an included timezone (from an external source) in Excel/VBA, to a normal Excel Date. As far as I can tell, Excel XP (which is what we're using) doesn't have …

Read More