Formula to convert minutes into hours

[exceluser9]

Hi Team,

I have a data as below, im looking for a formula to convert minutes in to hours i would require the result as mentioned in column B.

Please could you help?

Column A	Column B Result required
21	0.21
56	0.56
48	0.48
68	1.08

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[popipipo]

Put this formula in B1:

=A1/(24*60)

With celformat u.mm

 

[DRSteele]

I don't understand. A minute is 1/60th of an hour. So 21 minutes is 21/60 hours, or 0.35 hours.

Explain please.

 

[popipipo]

1 = 1 day = 24 hour
1 hour = 1/24
1 minute =1/(24*60)