convert time to fractions 1/24/ 2/24 etc

[lezawang]

Hi

I want to convert time to general (number). I want the numbers to be appeared like this 1/24, 2/24, 3/24,...., 24/24
I changed times to fractions format but I did not get what I want. In some cases like 10:00 pm, the fraction format changed it to 1 instead of 22/24.

Thank you very much

[TABLE="class: grid, width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]1:00 AM[/TD]
[TD="width: 64, align: right"]0 [/TD]
[/TR]
[TR]
[TD="align: right"]2:00 AM[/TD]
[TD="align: right"]0 [/TD]
[/TR]
[TR]
[TD="align: right"]3:00 AM[/TD]
[TD="align: right"] 1/8[/TD]
[/TR]
[TR]
[TD="align: right"]4:00 AM[/TD]
[TD="align: right"] 1/6[/TD]
[/TR]
[TR]
[TD="align: right"]5:00 AM[/TD]
[TD="align: right"] 1/5[/TD]
[/TR]
[TR]
[TD="align: right"]6:00 AM[/TD]
[TD="align: right"] 1/4[/TD]
[/TR]
[TR]
[TD="align: right"]7:00 AM[/TD]
[TD="align: right"] 2/7[/TD]
[/TR]
[TR]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"] 1/3[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"] 3/8[/TD]
[/TR]
[TR]
[TD="align: right"]10:00 AM[/TD]
[TD="align: right"] 3/7[/TD]
[/TR]
[TR]
[TD="align: right"]11:00 AM[/TD]
[TD="align: right"] 1/2[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"] 1/2[/TD]
[/TR]
[TR]
[TD="align: right"]1:00 PM[/TD]
[TD="align: right"] 1/2[/TD]
[/TR]
[TR]
[TD="align: right"]2:00 PM[/TD]
[TD="align: right"] 4/7[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"] 5/8[/TD]
[/TR]
[TR]
[TD="align: right"]4:00 PM[/TD]
[TD="align: right"] 2/3[/TD]
[/TR]
[TR]
[TD="align: right"]5:00 PM[/TD]
[TD="align: right"] 5/7[/TD]
[/TR]
[TR]
[TD="align: right"]6:00 PM[/TD]
[TD="align: right"] 3/4[/TD]
[/TR]
[TR]
[TD="align: right"]7:00 PM[/TD]
[TD="align: right"] 4/5[/TD]
[/TR]
[TR]
[TD="align: right"]8:00 PM[/TD]
[TD="align: right"] 5/6[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 PM[/TD]
[TD="align: right"] 7/8[/TD]
[/TR]
[TR]
[TD="align: right"]10:00 PM[/TD]
[TD="align: right"]1 [/TD]
[/TR]
[TR]
[TD="align: right"]11:00 PM[/TD]
[TD="align: right"]1 [/TD]
[/TR]
[TR]
[TD="align: right"]12:00 AM[/TD]
[TD="align: right"]1 [/TD]
[/TR]
</tbody>[/TABLE]

 

[alansidman]

Leza,

I took the list of hours as shown above. In the format section converted the time to a number (second item in format dropdown). I then converted the number to fraction (from dropdown the second item) "Up to 2 digits") Result is shown below

Data Range
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][/tr]
[tr][td]

1​

[/td][td]

1/24​

[/td][/tr]


[tr][td]

2​

[/td][td]

1/12​

[/td][/tr]


[tr][td]

3​

[/td][td]

1/8​

[/td][/tr]


[tr][td]

4​

[/td][td]

1/6​

[/td][/tr]


[tr][td]

5​

[/td][td]

5/24​

[/td][/tr]


[tr][td]

6​

[/td][td]

1/4​

[/td][/tr]


[tr][td]

7​

[/td][td]

7/24​

[/td][/tr]


[tr][td]

8​

[/td][td]

1/3​

[/td][/tr]


[tr][td]

9​

[/td][td]

3/8​

[/td][/tr]


[tr][td]

10​

[/td][td]

5/12​

[/td][/tr]


[tr][td]

11​

[/td][td]

11/24​

[/td][/tr]


[tr][td]

12​

[/td][td]

1/2​

[/td][/tr]


[tr][td]

13​

[/td][td]

13/24​

[/td][/tr]


[tr][td]

14​

[/td][td]

7/12​

[/td][/tr]


[tr][td]

15​

[/td][td]

5/8​

[/td][/tr]


[tr][td]

16​

[/td][td]

2/3​

[/td][/tr]


[tr][td]

17​

[/td][td]

17/24​

[/td][/tr]


[tr][td]

18​

[/td][td]

3/4​

[/td][/tr]


[tr][td]

19​

[/td][td]

19/24​

[/td][/tr]


[tr][td]

20​

[/td][td]

5/6​

[/td][/tr]


[tr][td]

21​

[/td][td]

7/8​

[/td][/tr]


[tr][td]

22​

[/td][td]

11/12​

[/td][/tr]


[tr][td]

23​

[/td][td]

23/24​

[/td][/tr]


[tr][td]

24​

[/td][td]

1​

[/td][/tr]
[/table]

 

[shg]

Just change the format of the time column to ?/24

 

[lezawang]

?/24 is amazing. Thank you so much.