Convert Minutes into Hours and Minutes

M

mschmidt

So if I have a cell with say 43,238 minutes, I would like to convert
into Hours and Minutes.

thanks
 
P

Pranav Vaidya

Hi,
Suppose your data is in cell A1. Now type this formula in cell A2

=A1/60

Then select cell A2 and change the format of this cell to 'Time'.

HTH,
 
N

Niek Otten

divide by (60*24) and format Custom as [hh]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| So if I have a cell with say 43,238 minutes, I would like to convert
| into Hours and Minutes.
|
| thanks
 
R

Roger Govier

Hi

Format the result cell, Format>Cells>Number>Custom>[h]:mm
Use the formula =A1/1440

Excel stores times as fractions of a day, so divide by 60 then by 24 hence
divide by 1440
 
D

David Biddulph

And have you checked the answer which that formula gives you, Pranav?
Either 15:12 or 17295:12 (depending on formatting) seem unlikely answers.
Perhaps a further division by 24 may be worth trying? :)
 

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

I have 3053 minutes and I want to convert to hours and minutes 2
dividing a number into hours and minutes 1
Concerting total minutes to hours and minutes 7
I need to convert 157.25 minutes, into hours, minutes and seconds. 1
CONVERT HOURS AND MINUTES TO INT 3
Help with time formatting 2
Need to convert hours and minutes to hours and tenths. 2
Converting hours into minutes 2

Top