lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
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 AM | 0 |
2:00 AM | 0 |
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 PM | 1 |
11:00 PM | 1 |
12:00 AM | 1 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>