Menu
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
459
Another quick way to combine date and time in Excel is by using the CONCAT formula with the TEXT function. Suppose you have a dataset as shown below and you want to combine the date and time and get the result in column C. The TEXT function allows you to take any value as the input and show it in the specified format.
How to Combine text with Date & Time here is the solution. Enter this formula =Concatenate(A3,” “,TEXT(B3,”mm/dd/yyyy”) into a blank cell besides your data. Or alternatively can use the second formula as =A4&” “&TEXT(B4,”dd/mm/yyyy”) into a black cell besides your data.
To use this function, select the cell where you want the combined time to appear. Then, type =CONCATENATE( into the cell, followed by the cells containing the times you want to combine. For example, if you wanted to combine the times in cells A1 and B1, you would type =CONCATENATE(A1,B1).
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
129
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
