Convert fraction 1/10 to 1/30

  • Thread starter Thread starter Thorbjorn Sundboe
  • Start date Start date
T

Thorbjorn Sundboe

I have a sheet where I calculate return on investment for some equipment. Is
there a function that converts 1/10th of a month to 1/30th so that my figure
is displayed as months,days?

Cheers, Thorbjorn
 
Not sure how you want to use the result. This formula returns a tex
result.

=INT(A1)&"-" &MOD(A1*30,30
 
Back
Top