For Astro - Dasa , Bhuthi Calculations

[satishwin123]

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.

 

[sdruley]

05.30.2013-06.04.10 - sdruley's library

This might get you started

 

[satishwin123]

05.30.2013-06.04.10 - sdruley's library

This might get you started

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

Hi,

I want to add the both

Year Mon Day Hr Min
1978 06 19 07 15
0000 01 20 09 36
-------------------------------

--------------------------------
Note- By default a month hold 30 days only.

Thanks
Sat.

 

[satishwin123]

Hi,

You can better take this data for the addition.


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

Year Mon Day Hr Min
1978 08 09 16 51
0000 04 09 14 24
--------------------

----------------------
I should get final added values as "1989-12-19-7-15."

But I am getting "1989-12-18-7-15." by using the below formula.
=DATE(SUM(A1:A2),SUM(B1:B2)+INT(SUM(C1:C2)/30),MOD(SUM(C1,C2),30)) + TIME(D1+D2,E1+E2,0)

In the Time factor, if the hour is more than 24, the quotient part should add to the day component.
Hour ==> 16+14 = 30 hrs. So 1 day & 6 hour.
Min==> 51+24 = 75 min. 1 hr & 15 min.
The Hr becomes as 7 ( 6 hr + 1hr)
The Min is 15 min.
The day should be added with one (ie., 1 day [Hour ==> 16+14 = 30 hrs. So 1 day & 6 hour.])

Note- By default a month hold 30 days only.

Thanks
Sat.

 

[satishwin123]

Dear All,

Pl. give some excel formula to achieve this date increment with hours.


Year Mon Day Hr Min
1978 08 09 16 51
0000 04 09 14 24
--------------------
1978-12-19-7-15.
----------------------
Thanks
Sat