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

<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>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="align: center"]mm[/TD]
[TD="align: center"]dd[/TD]
[TD="align: center"]yyyy[/TD]
[TD="align: center"]hh[/TD]
[TD="align: center"]mm[/TD]
[TD="align: center"]ss[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]2019[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]0[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]10/16/2019 9:30:00 AM[/TD]

</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