creating a date and time from two cell values

[tonywatsonhelp]

Hi Everyone,

I'm looking for a way to create a Date (dd/mm/yy hh:mm:ss) from two cells

A2 = "24/01/2018 00:00:00"
and A3 = 12.00 (this can be changed to another formate if easier but a number is likely

how can I combine the two to get "

"24/01/2018 12:00:00" but actually as a date not just text?

thanks

Tony
​

 

[mole999]

if the A3 could be 12:00 rather than 12.00 then in A1 =A2+A3, as they are both numeric, at a push =--A2+--A3 or =--SUM(A2+A3). Otherwise the 12 has to be reduced, by dividing by 24

 

[AlanY]

or you can try this, and format the cell to date/time accordingly

Excel 2013/2016
	A	B	C
1
2	"24/01/2018 00:00:00"		24/01/2018 12:30:00
3	12.50
Sheet1

Cell Formulas
Range	Formula
C2	=MID(A2,2,LEN(A2)-2)*1+A3/24