Fraction Formatting

I am creating an employee time sheet, where the hours worked will be entered
in increments as small as 15 minutes and be displayed as fractions. For
example, I would like 2.5 hours to display as "2 1/2" and 4.25 hours to
display as "4 1/4". When I choose "Fractions" in the cell formatting and
select the fraction denominator as '4', 2.5 hours displays as 2 2/4, not 2
1/2.

How do I set the formatting to display as I want?

TIA
David

David

just format it as "Up to two digits (21/25)"

Regards

Trevor


"David Rose" <drose@compasscon.com> wrote in message
news:eCPoRH6PFHA.3716@TK2MSFTNGP14.phx.gbl...
>I am creating an employee time sheet, where the hours worked will be
>entered in increments as small as 15 minutes and be displayed as fractions.
>For example, I would like 2.5 hours to display as "2 1/2" and 4.25 hours to
>display as "4 1/4". When I choose "Fractions" in the cell formatting and
>select the fraction denominator as '4', 2.5 hours displays as 2 2/4, not 2
>1/2.
>
> How do I set the formatting to display as I want?
>
> TIA
> David
>

Select <fraction> <up to two digits>.

--
Greetings from New Zealand

Bill K


"David Rose" <drose@compasscon.com> wrote in message
news:eCPoRH6PFHA.3716@TK2MSFTNGP14.phx.gbl...
>I am creating an employee time sheet, where the hours worked will be
>entered in increments as small as 15 minutes and be displayed as fractions.
>For example, I would like 2.5 hours to display as "2 1/2" and 4.25 hours to
>display as "4 1/4". When I choose "Fractions" in the cell formatting and
>select the fraction denominator as '4', 2.5 hours displays as 2 2/4, not 2
>1/2.
>
> How do I set the formatting to display as I want?
>
> TIA
> David
>

Thank you both for the help!

David

"Bill Kuunders" <bill.kuunders@xtra.co.nz> wrote in message
news:Oa6FAS6PFHA.904@tk2msftngp13.phx.gbl...
> Select <fraction> <up to two digits>.
>
> --
> Greetings from New Zealand
>
> Bill K
>
>
> "David Rose" <drose@compasscon.com> wrote in message
> news:eCPoRH6PFHA.3716@TK2MSFTNGP14.phx.gbl...
>>I am creating an employee time sheet, where the hours worked will be
>>entered in increments as small as 15 minutes and be displayed as
>>fractions. For example, I would like 2.5 hours to display as "2 1/2" and
>>4.25 hours to display as "4 1/4". When I choose "Fractions" in the cell
>>formatting and select the fraction denominator as '4', 2.5 hours displays
>>as 2 2/4, not 2 1/2.
>>
>> How do I set the formatting to display as I want?
>>
>> TIA
>> David
>>
>
>