satishwin123
New Member
- Joined
- Apr 8, 2013
- Messages
- 8
Hi,
I need to add year, month, day, Hr and Min to the another date for Astro (Dasa,Bhuthi Calaculation).
I need a excel formula to add so.
Note:
1) For this calculation,by default 30 is number of days per month.
2) Here all months to be considered as 30 days.
3) All the elements(yr,mon,day,hr,min) will be in individual cell.
For Eg:
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.
I need to add year, month, day, Hr and Min to the another date for Astro (Dasa,Bhuthi Calaculation).
I need a excel formula to add so.
Note:
1) For this calculation,by default 30 is number of days per month.
2) Here all months to be considered as 30 days.
3) All the elements(yr,mon,day,hr,min) will be in individual cell.
For Eg:
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.