Calculate time difference in Excel?
444067
Put this in C1:\n\n=(12-A1)-(12-B1)\n\nHave the cell formated to time.
865459
just use the formula avg.speed=distance/time\nfor km/hr change time to 2.25 hr\nand for m/sec change distance to 500000m and time to 135*60sec\ndo these ques yourself. in exams you won't have yahoo answers\n:)
916539
1.  Open Excel\n2.  On the top tool bar click the question mark\n3.  In the Office Assistant text box \ntype in\nCalculate the difference between two dates\n\nYou will be given the step by step instructions.\n\nk\np.s.  Use the Office Assistant for \nlots of functions \nincluding getting all sorts of formulas.
201488
Select the cells that will have your original swim times, right click, and then click 'format cells'. Under the tab 'number' scroll down and click 'custom'. Type in mm:ss.00.\n\nThen, when you type in your swim times, be sure to format them such as 5:33.33 <--- use a '.' instead of a ':' to seperate your 100ths.\n\nYou can then use the average function to calculate the average.\n\nContact me if you need any more help.
346778
use time function. =time() and use add and subtract formulas to customize as per ur requirement
267870
10:15+ (90/4) = 10:37.5, but that doesn't really matter, b/c the next time when the overlapping/little over fifteen minutes later thing works is 3:15, to 3:33 (you could even say 33 seconds as well) and then 3:33 and 33 secs + 4.5 hours =\n\nSally woke up at 8:03 and 33 seconds
556307
I think what you're looking for is the "equation of time", which is the difference between local mean time and local apparent time.  The term "difference" is used because "variance" has a very specific mathematical meaning.   Local apparent time is determined by the position of the sun in the sky.  local mean time is based on Greenwich Mean Time.  The difference occurs because GMT is based upon a fixed rotational rate, and local apparent noon is determined is by the maximum altitude of the sun in the sky.\n\nThe two time scales differ by as much as 15 minutes.  The web page below has more details.\n\nThere are formulas for this, but they are complex calculations.  The equation of time changes constantly, although the change is very slow, so a graph of the difference in 1980 is still mostly correct for 2006.  You'll be accurate to within a few seconds.
750435
Why not use four columns for each date with the time of each admission or discharge in the cells?\n\nDay Admission.... Day Discharge.... Night Admission.... Night Discharge\n8:00 am.... 8:30 am.... 6:00 pm.... 7:00 pm\n8:15 am.... 10:00 am.... 6:15 pm.... 9:00 pm\n9:15 am.... 11:00 am.... 11:15 pm.... 10:00 pm\nblank.... 12:00 pm.... blank.... 10:15 pm\nblank.... blank.... blank.... 10:45 pm\n\n\nThis way you could have some other cells use the count function to calculate that in the above example there were three day admissions, four day discharges, 3 night admissions, and 5 night discharges.
1107392
1) Count the number of hours you worked on Monday\n2) Type that number into the calculator and then press the + sign\n3) Count the number of hours you worked on Tuesday\n4) Type that number into the calculator and press +.\n\nKeep doing for every day and once you've put in all of your numbers, press the = sign.
1096663
A=1000 +.05*t\nB=1500+d*t\nday^-1 cancels with the unit of time days\n3(1000+.05*t)=1500+d*t\n3000+.15*t=1500+d*t\n3000-1500=d*t-.15*t\n1500=d*t-.15*t\n1500=(d-.15)t\n1500/(d-.15)=t\nt is how long it well take.\nIf d is equal to or less then .15 culture B well never have 3 times as many cells as A.
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
741279
Total distance traveled divided by total time in transit.\n\nr = d/t.
401014
What you need to do is enter the beginning time and ending time in 2 different cells.  Highlight all the cells that include time and click Format in the standard toolbar.  Then click Cells, when the window opens select the Format tab and chose the Time option in the right.   Select the time format that works best for you and click OK.  Then type the formula and make sure that that cell is also formatted as a time type cell.  If you are just calculating how long people are working a simple B-A forum la would help.
696298
1st way :-\ndistance = speed x time = 55 mph x 3 h = 165 m\n\n2nd way :-\ngiven that d = 55t , so on putting t = 3hrs , we get d = 165 m
153627
10 minutes on a 100 minute clock is 1/10 of an hour = 6 minutes on a regular clock. Take you 100 minute clock minutes, divide by 10 and multiply by 6 ( or divide by 5 and multiply by 3).
943548
36\n\nFirst time= x-(x/2+2) = x/2-2\nSecond time=x/2-2-(1/2(x/2-2)+2)=x/4-3\nThird time=x/4-3-(1/2(x/4-3)+2)=x/8-3.5\nx/8-3.5=1
823225
To figure out "regular time" from military time, \nif it's over 12:00 subtract 12:00 from the time \nand you'll have your answer.\nSo 18:21 - 12:00 = 6:21\nSince it was over 12:00 you know it's pm.\n6:21 PM