# Minutes into Hours and Minutes

#### Chris Williamson

##### Board Regular
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

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### ChrisBM

##### Board Regular
B1 = INT(A1/60)
C1 = A1 - (B1 * 60)

KR
Chris

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

Thank you,

Replies
1
Views
89
Replies
6
Views
177
Replies
3
Views
118
Replies
3
Views
55
Replies
3
Views
66