Turning fractions in to decimals

[tom hatten]

In the attached file, I copy the fixtures and odds in to column A. In column B and C, I would like the Home and Away odds to show as decimals. Column D shows the difference between column C and B.
Column B is deducted from column C to show a higher number for the home team in column D. A negative number in column D would indicate and advantage for the away team.

I don't know the formlua to convert fractions to decimals and place them in the appropiate columns.

If someone could help, I'd be most grateful.

Thank you.

[AliGW]

Still using Excel 2016?

[tom hatten]

No, I use Google Sheets but couldn't find a way to download the file. I'm using the Excel app I have on my computer.

[AliGW]

Which version of Excel?

[tom hatten]

I can't find the version in User Information but it's part of Microsoft 365 if that's any help?

[AliGW]

That is the version! Please add 365 to your profile.

If you want this to work in Google Sheets, then I shall move this to the appropriate section for you.

[tom hatten]

I've updated my profile. If you have a solution for Microsoft 365, I'd be very grateful. Thank you.

[AliGW]

In F2 copied down:

=LET(t,TAKE(TEXTSPLIT(A2,," "),-3),h,TAKE(t,1),a,TAKE(t,-1),ho,TEXTBEFORE(h,"/")/TEXTAFTER(h,"/"),ao,TEXTBEFORE(a,"/")/TEXTAFTER(a,"/"),HSTACK(ho,ao,ao-ho))

[tom hatten]

Thank you very much

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.