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?

[TABLE="width: 232"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B Result required[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]0.21[/TD]
[/TR]
[TR]
[TD]56[/TD]
[TD]0.56[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD]0.48[/TD]
[/TR]
[TR]
[TD]68[/TD]
[TD]1.08[/TD]
[/TR]
</tbody>[/TABLE]

 

[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)