View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default Calculate percentage of time period

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.