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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks