Converting minutes to hours and minutes

[dirwin]

I am new to the forum & have question:

Is there an Excel function or formula that, when number of minutes is entered, will return hours and minutes in the format hh:mm? For example, if the number of minutes entered is 150, the returned value is 2:30.

Thanks, //Dennis

[solnajeff]

Hi

Try the following link which takes you to a very good set of examples from C. Pearson.

http://www.cpearson.com/excel/DateTimeEntry.htm

Regards

Jeff

[dirwin]

I'm heading over to the link you provided.

Thanks again, //Dennis//

[daddylonglegs]

I am new to the forum & have question:

Is there an Excel function or formula that, when number of minutes is entered, will return hours and minutes in the format hh:mm? For example, if the number of minutes entered is 150, the returned value is 2:30.

Thanks, //Dennis

Just divide by 1440 (the number of minutes in a day), i.e. if A1 contains the number 150 use this formula in another cell

=A1/1440

format as [h]:mm

[dirwin]

Thanks for a perfectly logical & simple solution!

Cheers, //Dennis//