Date Calculation - Astro Calculation

K

kskwin

Joined
May 3, 2013
Messages
2
Reaction score
0
Hi,

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

Note: For this calculation,30 is number of days per month (default to all months)

Eg,

To add 20days, 9hr and 36 minutes to 18-06-1978 07 15

Yr Mon Day Hr Min
1978 06 18 07 15
0000 01 20 09 36
----------------------------
Yr Mon Day Hr Min -?
-------------------------------

Pl. provide a formula to get this arrived.

Thanks
 
within your Excel file, do you know how your dates are stored? Are they stored as Date values, or as Text? Are you looking to add the same amount to each date? Or do you want to round off the date to the 30th of the month?
 
alow said:
within your Excel file, do you know how your dates are stored? Are they stored as Date values, or as Text? Are you looking to add the same amount to each date? Or do you want to round off the date to the 30th of the month?
Click to expand...



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
 
Back
Top