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

G

Guest

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
 
B

Biff

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
 
D

Dnereb

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert minutes into hours 3
Excel functions 2
coverting minutes to hours and minutes 1
Converting hour/minutes to hours/hundredths 1
to convert Minutes into Day:Hr:min (not as fraction) 2
Converting a number to hours and minutes 4
Convert minutes into hours and minutes 6
convert decimal numbers to a fraction of an hour for payroll hour 4

Top