Add year,month,day,hours and min

[satishwin123]

Hi Friends,
I need an excel formula to Add year,month,day,hours and min which are placed in a each column. The resultant date format (dd/mm/yyyy HH:MM) should be in a single cell.

Pl. refer the snap for quick details and help in.

Thanks
Sat.

 

[Oeldere]

=year(a1)
=month(a1)
=day(a1)
=hour(a1)
=minut(a1)

 

[satishwin123]

Hi,

Pl. find below the snippet.

[TABLE="width: 539"]
<tbody>[TR]
[TD]Year[/TD]
[TD]Month[/TD]
[TD]Date[/TD]
[TD]Hour[/TD]
[TD]Min[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]1982[/TD]
[TD]10[/TD]
[TD]28[/TD]
[TD]14[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]15[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1983[/TD]
[TD]11[/TD]
[TD]30[/TD]
[TD]5[/TD]
[TD]50[/TD]
[TD]30/11/1983 5:50[/TD]
[/TR]
</tbody>[/TABLE]

 

[barry houdini]

Do you want formulas to get the third row of your example - will you always be adding just two rows or do you need to add multiple rows?