Format fractions

[lunker55]

I am converting minutes into fractions.
60 minutes should be 1
75 minutes should be 1 1/4
90 minutes should be 1 1/2

I have formatted in quarters, so 1/2 shows as 2/4.
Is there a format to change 2/4 to 1/2?
I don't want 2/3's or 4/7th's

Any ideas?

joe

 

[Serkan]

Assume A1 contains the number in minutes, say 90

Type in Cell A2

=A1/60

Then from the Format menu selecet Cells/Fraction/Up to One
Digit(the first option)

This will do...

 

[lunker55]

That is what I have done, but when I enter 25 minutes, I get 3/7.
I suppose I'll have to round to the nearest quarter.
Do you know how to round to the nearest quarter?

joe

 

[JE McGimpsey]

One way:

=ROUND(A1/"00:15")*"00:15"

or, equivalently, since XL stores times as fractional days and 24 hours
is 96 quarter-hours:

=ROUND(A1*96,0)/96

 

[Guest]

Hi Joe
The following will convert minutes into hours and will round to the nearest 1/4 in one step

=ROUND(A1/60*4,)/

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- lunker55 wrote: ----

That is what I have done, but when I enter 25 minutes, I get 3/7
I suppose I'll have to round to the nearest quarter
Do you know how to round to the nearest quarter

jo

 

[lunker55]

Thank you Mark,
Exactly what I needed!

joe

Hi Joe,
The following will convert minutes into hours and will round to the nearest 1/4 in one step:

=ROUND(A1/60*4,)/4

Good Luck,
Mark Graesser
(e-mail address removed)
Boston MA

----- lunker55 wrote: -----

That is what I have done, but when I enter 25 minutes, I get 3/7.
I suppose I'll have to round to the nearest quarter.
Do you know how to round to the nearest quarter?

joe