Minutes into Hours and Minutes

Chris Williamson

Board Regular
Joined
Oct 16, 2010
Messages
82
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
 

Some videos you may like

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.

Watch MrExcel Video

Forum statistics

Threads
1,109,329
Messages
5,528,033
Members
409,799
Latest member
mlewan_ca

This Week's Hot Topics

Top