To convert minute into hour and minute

[Guest]

How to convert 250 minutes into 4 hours and 10 minutes? Which the formula

The result of one determined function is 250. I would like from this value to convert it into 4 hours and 10 minutes (4:10). How I make

The formula counts the numbers of times, during one week, that it has lessons of Mathematics. The result is 5 lessons, being that 1 lesson of mathematics corresponds the 50 minutes. Then I multiply 5*50=250. What I want is that value 250 either converted into 4h and 10min or 4:10 hours

Thank

 

[Alan]

Enter the 50 minutes as 00:50, multiply by 5 = 4:10
To get the time as decimal 00:50*5*24 = 4.167

How to convert 250 minutes into 4 hours and 10 minutes? Which the formula?

The result of one determined function is 250. I would like from this value

to convert it into 4 hours and 10 minutes (4:10). How I make?

The formula counts the numbers of times, during one week, that it has

lessons of Mathematics. The result is 5 lessons, being that 1 lesson of
mathematics corresponds the 50 minutes. Then I multiply 5*50=250. What I
want is that value 250 either converted into 4h and 10min or 4:10 hours.

 

[Arvi Laanemets]

Hi

=250/(24*60)
Format the cell with formula as "h:mm", "hh:mm" or "[h]:mm"

--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

How to convert 250 minutes into 4 hours and 10 minutes? Which the formula?

The result of one determined function is 250. I would like from this value

to convert it into 4 hours and 10 minutes (4:10). How I make?

The formula counts the numbers of times, during one week, that it has

lessons of Mathematics. The result is 5 lessons, being that 1 lesson of
mathematics corresponds the 50 minutes. Then I multiply 5*50=250. What I
want is that value 250 either converted into 4h and 10min or 4:10 hours.