Fraction Formatting

[David Rose]

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

 

[Trevor Shuttleworth]

David

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

Regards

Trevor

 

[Bill Kuunders]

Select <fraction> <up to two digits>.

 

[David Rose]

Thank you both for the help!

David

Select <fraction> <up to two digits>.