Minutes into Hours and Minutes

[Chris Williamson]

Hi Guys,</SPAN></SPAN>

I need some help with this task that I’m trying to work out please.</SPAN></SPAN>

In cell A1 this will have a number (this number represents the number of minutes).</SPAN></SPAN>

If the number is less than 60 I do not have any problems, however if the number is greater than 60 I run into some problems.</SPAN></SPAN>

If cell A1 is showing 129 minutes, I would like cell B1 to display the number of hours and cell C1 to display the remaining number of minutes.</SPAN></SPAN>


Example</SPAN></SPAN>
A1 = 129</SPAN></SPAN>
B1 = 2 hours (formula required)</SPAN></SPAN>
C1 = 9 minutes (formula required)</SPAN></SPAN>

Thanks</SPAN></SPAN>


Chris

 

[ChrisBM]

B1 = INT(A1/60)
C1 = A1 - (B1 * 60)

KR
Chris

 

[BadgerRoad]

In B1 =Int(A1/60)
In B2 =A1-A2*60

 

[Chris Williamson]

Thank you,