Sorry, I'm getting no results. The formulas you indicated start with a date
and I'm working with "time quantities", like 8 years, 20 years, etc., which
will be greater or lesser in some percentage. Is what Im saying
understandable?

"Niek Otten" escreveu:

See

http://www.cpearson.com/excel/datedif.htm

--
Kind regards,

Niek Otten

"Ricardo Monteiro :^)" wrote in
message ...
Cell A1 shows prison time for a certain crime (eg. 8 years).
How would cell B1 show 1/5 (20%) of that in time format (ie, not 1,6; but
1
"year" 7 "months").
I suppose I want a duodecimal system instead of a decimal one...
Thanks in advance.