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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel date problem 3
Formula to calculate pro-rate + 1 month 3
Return Value Based on Two Others 1
Bargain 30GB for £10 a month on a 1 month contract. 4
Excel 1 vs 10 in Excel Formula 0
Excel Progress Bar Showing Progress of Month 0
fraction display error 8
Convert Decimal fractions to binary and vice versa 1

Back
Top