Format for entering durations in years and months [closed]
Hi, I am looking for a way to enter time durations involving years and months. Ideally in the format YY-MM
. But when I set the format to such a format and try to enter "6 months" as 00-06
, it is interpreted as 2000-06 (displayed as 00-06
though), whereas adding this date to another date adds another 100 years, because LibreOffice's epoch seems to be 1900-01-01.
So, how can I manually enter durations and visually see if they were entered correctly?
Note: As a programmer I know that working with times is a PITA, always.
Needinfo
What do you expect to be the actual content of a cell,where you entered the "YY-MM" thing"? Should it be a text or a numeric value? How should the final durations be represented?
Please go into the details.
> What do you expect to be the actual content of a cell That does not really matter that much to me, I don't care if it's a string or numeric. The outcome should not be a duration, but a date.