To convert minute into hour and minute

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Enter the 50 minutes as 00:50, multiply by 5 = 4:10
To get the time as decimal 00:50*5*24 = 4.167
Lyco said:
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
Click to expand...
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
Click to expand...
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.
 
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

Lyco said:
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
Click to expand...
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
Click to expand...
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.
 
Back
Top