Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi again! It just got slightly more complicated (or at least for me). Here is
an example to get the problem more clear: Mister X worked for a couple of periods in our company: start date end date years months days 19.12.2003 13.09.2005 1 8 25 09.10.2005 01.11.2006 1 0 23 09.11.2006 20.01.2008 1 2 11 total 3 10 59 As we see it the ex the # of days corresponds to more than a month. The question is: how do I convert if it is necessary the # of days in months, months years, taking into consideration that a month could be 28, 29, 30 and 31 days long. Thanks very much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert number of days into years/months | Excel Discussion (Misc queries) | |||
how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
How do I convert a number into Years, Months, Days format? | Excel Worksheet Functions | |||
how to convert 12/10/1970 to years/months/days | New Users to Excel | |||
convert Days to Years, Months, Days | Excel Discussion (Misc queries) |