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.

Year	Month	Date	Hour	Min	Result
1982	10	28	14	30
1	1	1	15	20
1983	11	30	5	50	30/11/1983 5:50

<tbody>
</tbody>

 

[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?