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

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,543
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

1:00 AM0
2:00 AM0
3:00 AM 1/8
4:00 AM 1/6
5:00 AM 1/5
6:00 AM 1/4
7:00 AM 2/7
8:00 AM 1/3
9:00 AM 3/8
10:00 AM 3/7
11:00 AM 1/2
12:00 PM 1/2
1:00 PM 1/2
2:00 PM 4/7
3:00 PM 5/8
4:00 PM 2/3
5:00 PM 5/7
6:00 PM 3/4
7:00 PM 4/5
8:00 PM 5/6
9:00 PM 7/8
10:00 PM1
11:00 PM1
12:00 AM1

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,097
Office Version
2019
Platform
Windows
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
A
1
1/24​
2
1/12​
3
1/8​
4
1/6​
5
5/24​
6
1/4​
7
7/24​
8
1/3​
9
3/8​
10
5/12​
11
11/24​
12
1/2​
13
13/24​
14
7/12​
15
5/8​
16
2/3​
17
17/24​
18
3/4​
19
19/24​
20
5/6​
21
7/8​
22
11/12​
23
23/24​
24
1​
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,721
Office Version
2010
Platform
Windows
Just change the format of the time column to ?/24
 

Forum statistics

Threads
1,085,047
Messages
5,381,381
Members
401,735
Latest member
ranjithr

Some videos you may like

This Week's Hot Topics

Top