How to type a ratio - changes to a time

Discuss the spreadsheet application

How to type a ratio - changes to a time

Postby edi » Tue May 05, 2020 4:26 am

For example, 1:2 converts to 01:02:00 AM
I'm trying to make a list of ratios and can't find how to change this. Seems like it should be basic but every search I do on the Help & online takes me to every other more complex situation.
Does this even when I put spaces between the two, which isn't preferable because it's disorienting. As is 1::2 but that's what I'm doing for now.
Thanks in advance!
open office 4.1.6 on windows 10
edi
 
Posts: 1
Joined: Tue May 05, 2020 4:21 am

Re: How to type a ratio - changes to a time

Postby FJCC » Tue May 05, 2020 4:42 am

If you are using the ratio as a label, you can format the cell as text using the menu item Format -> Cells. On the Numbers tab set the Category to Text.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7748
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to type a ratio - changes to a time

Postby Zizi64 » Tue May 05, 2020 5:58 am

you can format the cell as text using the menu item Format -> Cells.


Use the Cell styles instead of direct (manual) formatting method.


And you can use the Ratio format code:
Code: Select all   Expand viewCollapse view
#?/?

if you want numeric values. You can type-in the value as a constant 0.5, or as a formula =3/4 or some other way. The value will be appeared as 1/2 | 3/4 when you format the cell with the custom Cell style. My sample file was created in my LibreOffice 6.2.8:

Cell style MyRatio.ods
(8.12 KiB) Downloaded 15 times
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9542
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: Zizi64 and 24 guests