For Astro - Dasa, Bhuthi Calculation

I need to add year, month and day with time to the date for Astro (Dasa,Bhuthi Calaculation).I need a excel formula to add so.

Note: For this calculation,by default 30 is number of days per month.

Here all months to be considered as 30 days. All the elements(yr,mon,day) will be in individual cell.

A1=1978,B1=05,C1=29 D1=00,E1=00
A2=0000,B2=00,C2=20,D2=09,E2=36

Year = A1,A2
Month=B1,B2
Day=C1,C2
Hr=D1,D2
Min=E1,E2


Year Mon Day Hr Min
1978 05 29 00 00
0000 00 20 09 36
-------------------------------

--------------------------------

Let me know the excel formula.

Thanks.
Say.

Dear Friends,
I need a excel formula to add Year,month,day,hours,min which are placed in each column. The resultant date should be in a single cellCalc.jpg

Thanks for this formula