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.