Time value to contain Months/Date/Year Hour:Minutes:Seconds AM/PM

[hsandeep]

I need time containing Months/Date/Year Hour:Minutes:Seconds AM/PM as shown in I2 with input cells being B2:G2
How to accomplish?
I am using Excel 2007
Sheet1

	B	C	D	E	F	G	H	I
1	mm	dd	yyyy	hh	mm	ss
2	10	16	2019	9	30	0		10/16/2019 9:30:00 AM

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 12px"><col style="WIDTH: 148px"></colgroup><tbody>
</tbody>

 

[Scott R]

=date(c2, a2, b2) + time(d2, e2, f2)

 

[hsandeep]

=date(c2, a2, b2) + time(d2, e2, f2)

Not getting..may be because of a2!!

 

[Scott R]

Oops. Yeah, slide everything one cell to the right. DATE(D2,B2,C2) + TIME(E2,F2,G2)

 

[hsandeep]

Oops. Yeah, slide everything one cell to the right. DATE(D2,B2,C2) + TIME(E2,F2,G2)

Thats it..IT WORKS. Thanks Scott R