What is the excel formula to convert number of minutes to hours, convert 225 mins to 3h 45m. 225/60 is 3.75 Tx
447208
OK. two things to do. Let's assume your 225 minutes are in cell A1\n\n\n=INT(A1/60) ;This gives you the hours\n\nNext\n\n=MOD(A1/60) ; This gives you the remaining minutes.
655269
set a equation: x is the # of periods. 4x=225 x= 56 1/4
214863
I can do this with a couple formulas. Let's say your seconds field is A1. Make field B1 this formula:\n\n=INT(A1/60)\n\nThat will give you the total number of minutes. Then make C1 this formula:\n\n=sum(a1-(b1*60))\n\nThat will give you the leftover seconds. There is probably a cleaner way to do this, but I only know what I taught myself.
535480
30: 3*2*5\n21: 7*3\n\nThe End
1099086
you need to set up a chart with two rows and 3 columns. the columns are rate, time, and distance ... and remember that rate * time = distance. let's call "X" the number of hours the plane takes to fly to TX. since rate is in mph, so should the time be, so remember that 40 min = 2/3 hour.\n\n\n\n.......................................     rate.........   time .......distance\nrow one is the plane going: 600 .......   X  .......    600X\nrow two is coming back:     500 .......   X + 2/3....500(X+2/3)\n\nnow, the two distances are the same, since it is the same route. so, 600X = 500(X+2/3)\ndistributing on the right: 600X = 500X + (1000/3)\n\nnow, subtract the 500X from both sides: 100X = 1000/3\n\nlast, divide both sides by 100 to get: X = 3 1/3\n\nthat means that the plane took 3 hrs, 20 min to fly there, but that is not what the question asked. it asked the time from TX to NY, which was 40 minutes longer ... so 2/3 hour longer ... so it took 4 hours. \n\nThe problem also asks for the distance, so substitute that into either original equation in the distance column:\n       600(X) = 600(3 1/3) = 2000\n\nso, the distance from TX to NY is 2000 miles
873031
Ok this still gets me sometimes but the easiest way for me to do it is to add 12 to the time then stick on 00 on the end \n\nfor example.  2pm\nyou add 12 = 14\nadd 00 = 1400\n\nthe am hours you dont do anything to it, well you dont add 12.  \n\nso 1pm would be 1300\n2pm=1400\n3pm=1500\n4pm=1600\n5pm=1700\n6pm=1800\n7pm=1900\n8pm=2000\n9pm2100\n10pm=2200\n11pm=2300\nmidnight=2400
56860
31.536.000\nor\n31.622.400\n(depends if its a leap year)\n\nbtw...it's 1h has 60 mins...1 min has 60 secs....therefore it goes 60*60, which is 3600 secs\none day has 24 hours -> 24*3600 = 86.400 secs\nand finally 86.400 * 365, or 366 gives the upper results
1079160
50 - 39.48\n100 - 1:30.77\n200 - 3:11.45
411262
You need a special made function:\nTry this\nput start time in A1\nput end time in B1\nput this fumction in C1\n=HOUR(B1) -HOUR(A1)&":"&MINUTE (B1)-MINUTE(A1)\nThis will work if both time are in the same day\n\nI had to put spaces for you to read, remove them.\ne-mail me for further info\n\nXLMan
1003883
distance = rate times time or\nd = rt\nr = (x+100) mph\nt = (2x+3) hours\n\nd = rt\nd = (x+100)(2x+3)\nUse FOIL\nd = (x)(2x) + (x)(3) + (100)(2x) + (100)(3)\nd = 2x^2 + 3x + 200x + 300\nCombine like terms\nd = 2x^2 + 203x + 300
945900
Use Clock Arithmetic.\n\n11:25pm = 23:25\n\n6:03 - 23:25 = -17:22\n\ntake 24:00 - 17:22 = 6:38\n\nIn this case of Clock Arithmetic, all values are between 0:00 and 23:59.  If not, you have to adjust by 24 hrs.\n\nhint: unit circle concept\n\n-270 deg = 90 deg\n\nyou take 360 - 270 = 90
808842
Hi Gizmo,\n\nThese are all products of the relationship of various times to one hour or 60 minutes. You can prove this by:\n\n.25y=15mins\ny= 15mins/.25\ny=60mins\n\nTherefore, putting the 60 where it belongs and the new unknown value becoming the y, the equation for your question is:\n\ny(60)=40\ny=40/60\n\n40 minutes divided by the 60 will yield the ratio in fractional form:\n40/60 or 2/3 \n\nChange it to decimal:\n2/3=.6666666 repeating\n\nand since all formulas show two decimal places, round to .67.
774669
4 *0.48\n=1.92 hrs\n=1 hr and 0.92*60 min\n=1 hr and 55.2 min\n=1 hr 55min and 0.2*60 sec\n=1 hr 55 min and 12 sec
1009103
We have a formula:\nSpeed = Distance / Time\nhere Time= Distance /Speed.==D/S\nD=100km in both cases\nS1= 125km/hr; S2= 80km/hr\n\nT1=D/S1==100/125 hrs === 4/5hrs===4/5*60mins= 48mins\nT2=D/S2==100/80 hrs ===5/4 hrs ===5/4*60 mins= 75mins\n\nTime saved = T2-T1==75-48=27 mins.\n\nIs this clear buddy
984368
632 is number of minutes?\n\nthen hours are =FLOOR(632/10,1)\nminutes are =632-hours*10\n\nIn general Xl, represents time as decimals, and you can us\nHOUR and MINUTE functions.
31847
The answer is A. You mean to tell me you couldn't figure this out for yourself?\n\nHere's how it's done.\n\n1. The unit of measure is feet per hour (ft/h).\n\n2. There are 60 minutes in an hour.\n\n3. 30 minutes x 2 = 60 minutes, which is an hour, as mentioned in #2 above.\n\n4. Since you multiplied 30 minutes by 2, you should likewise multiply 1000 feet by 2. 1000 feet x 2 = 2000 feet. There's your answer. Got it?
458004
hi,\n\nUnder the new metric time (EEC directive 019473 - 2006) due to come in to place in all European countries by 2009 at the latest, a day will consist of two equal periods; a metday and a metnight.\n\nEach metday will be equal to 12 hours or 10 new methours and each methour will consist of 100 metmins.\n\nNow since 12 hours = 10 methours = 720 mins\nThen one methour = 72 minutes = 100 metmins\nThus one metmin = 72/100 mins\nSo one min = 100/72 metmins\nTherefore 15 mins = 1500/72 metmins\n\nIn decimal time 15 mins = 20.83333 metmins or 0.02083 of a metday.\n\nhope this helps PP