How do I convert a number of minutes into hours and minutes?

I need to convert a number stated in minutes into a format that reflects
Hours and minutes.
As an example: 722 minutes = 12 hrs 2 mins

Use a formula like

=A1/24/60

and format the cell for Time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"gyrkin" <gyrkin@discussions.microsoft.com> wrote in message
news:8C6210C4-A6F2-4E5D-9EE6-A3FFB6A79EC5@microsoft.com...
>I need to convert a number stated in minutes into a format that
>reflects
> Hours and minutes.
> As an example: 722 minutes = 12 hrs 2 mins

Hi!

Divide by 1440 and format the cell as [h]:mm

A1 = 722
B1 = =A1/1440
Format B1 as [h]:mm

To do it in place:

Enter 1440 in an empty cell
Copy that cell
Select A1
Paste Special>Divide>OK
Format as [h]:mm

Biff

"gyrkin" <gyrkin@discussions.microsoft.com> wrote in message
news:8C6210C4-A6F2-4E5D-9EE6-A3FFB6A79EC5@microsoft.com...
>I need to convert a number stated in minutes into a format that reflects
> Hours and minutes.
> As an example: 722 minutes = 12 hrs 2 mins

Tell you a secret
The date/time is stored in a double.
1 day = 1
12 hours = .5
6 hours = .25 etc....