problem of converting days months and years
 

Hi i have a problem in excel ..i m new of excel so dont have enough
knowledge so do help me ..suppose i have the following data
A2 = Years = 9
B2 = Months = 175
C2 = Days = 392

i want to calculate these months and dates as supoose i have 0 years 24
months and 32 days so answer should be as 2 years 1 month and 2 days
because (24 months = 2 years and 32 days = 1 month and 2 days are left
as in the column of days).......

so plz help me thanks in advance......bye take care friendssss


--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile: http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=568831

problem of converting days months and years
 

Do you want to add these to another date or just total them? If its the
former then you can add those to a date in D2 with

=D2+DATE(A2,B2,C2)

If it's the latter then do you always want to assume 30 days in a month
and therefore 360 days in a year?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568831

problem of converting days months and years
 

no friend its not like date..i have calculated these years months and
days from several dates.......

i assume taht there are 30 days in a month..so the excel sheet is like
this

A2=years=56
B2=months = 25
C2=days=32
i want to add these so i get the answer as A2=58 years B2=2 months and
C2=2 days...... (because 25 months = 2 years and 1 month years are
added to years column and 32 days = 1 month and 2 days this 1 month is
added to month column and 2 days are in the days column..)


--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile: http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=568831

problem of converting days months and years
 

Try these formulas

A3

=A2+INT((B2+INT(C2/30))/12)

B3

=MOD(B2+INT(C2/30),12)

C3

=MOD(C2,30)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568831