Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Re: Display a result in fraction form

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Solved

Jump to Solution

0
1191
0

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 16, 2023 10:46 AM

Hello there smart folks! I am building a base for small film productions, and the industry has some odd practices I have to work around. One of those is tracking scenes on scripts in page length in fractions - specifically 8ths.

For my personal tracking I have a column that just holds the size in the total number of 8ths (so instead of showing 1/8 page it is 1, 1 and 3/8 pages is 11) which I can then total into total number of 8ths.

I now need to convert that back into pages in fraction form to display on one of my reports. So say I have 10 scenes over 5 3/8 pages (so my total is 43). How do I create that 5 3/8 to display?

I hope this makes sense!

Solved! Go to Solution.

Reply

2 Solutions

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 16, 2023 11:26 AM

With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:

Whole Numbers formula:

ROUNDDOWN({Number of 8ths}/8, 0)

Remainders formula:

Fractions formula:

Remainders formula:

{Number of 8ths}-({Whole Numbers}*8)

IF({Whole Numbers}=0,

CONCATENATE(Remainders &"/8"),

IF(Remainders>0,

CONCATENATE({Whole Numbers} & " " & Remainders &"/8"),

{Whole Numbers}

)

)

Reply

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 16, 2023 07:39 PM

Here is another option ...

```
CONCATENATE(
ROUNDDOWN({Eigths}/8, 0),
IF(
MOD({Eigths}, 8),
" " & MOD({Eigths}, 😎 & "/8"
)
)
```

Reply

6 Replies 6

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 16, 2023 11:26 AM

With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:

Whole Numbers formula:

ROUNDDOWN({Number of 8ths}/8, 0)

Remainders formula:

Fractions formula:

Remainders formula:

{Number of 8ths}-({Whole Numbers}*8)

IF({Whole Numbers}=0,

CONCATENATE(Remainders &"/8"),

IF(Remainders>0,

CONCATENATE({Whole Numbers} & " " & Remainders &"/8"),

{Whole Numbers}

)

)

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 16, 2023 11:36 AM

Reply

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 16, 2023 07:39 PM

Here is another option ...

```
CONCATENATE(
ROUNDDOWN({Eigths}/8, 0),
IF(
MOD({Eigths}, 8),
" " & MOD({Eigths}, 😎 & "/8"
)
)
```

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jan 17, 2023 12:59 PM

What a fantastic community 🙂 Thank you ever so much!!!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 26, 2023 10:14 AM

I'm trying this one (ya reduced fields!) but keep getting errors for missing opening parenthesis?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Apr 07, 2024 11:10 PM