View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ricardo Monteiro :^)
 
Posts: n/a
Default Calculate percentage of time period

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.