exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
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]
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]