In Excel, how do I convert hours, minutes, seconds to minutes?
813501
Set cell A1 to 5:34:55 and some other cell to:\n\n=(HOUR(A1))*60+MINUTE(A1)+ IF(SECOND(A1)>30, INT(1+ SECOND(A1)/60), SECOND(A1)/60)
275388
It's been  a long time since I used excel but if I remember you just click "insert" then choose "formula" then find   "average" and choose the times you wanted to average by selecting the cells with the times you want to average. \nMake sure all your data is in the same time format and that  you have the right cells selected.\nEdit.\nIf you do not get a satisfactory answer here post this question in the sofware section. Many experts there.
997831
divisions of seconds, such as milliseconds, or one thousandths of a second
523597
Two Part Question, Part 1: Regarding your time adding problem, you just need to understand how Excel handles dates & times, and also how Excel displays them with certain formats.\n\nIn Excel, date and time are joined at the hip; they are always together.  You cannot have a date without a time and vice versa.  A date represents the number of days since January 1, 1900.  For example 400 is the value for February 3, 1901 at midnight, because that is 400 days from the turn of that century.\n\nBut what if you wanted to represent Feb 3, 1901 at 3:00 in the morning?  Excel stores the times as fractional values to the integer value of 400.  There are 24 hours in a day, so the value for that date & time would be 400+3/24, or 400.125.  This is how Excel stores the values, but how it displays them is entirely different.  I could enter the number 400.125 in a cell and then if I format it as a Time using an h:mm convention, "3:00" will be displayed.  In other words, the date component is there but not being shown.\n\nWhen you have 23:59 as a time and then it rolls back over to 0:00, all that means is that the day increased by one, and there are no new minutes or hours on that day.  To fix this you could format the cell using a custom format of "d:h:mm", that way when it said 0:23:59 and you added a minute, it would roll over to 1:0:00.  Experiment with different formats to see what you like.\n\nPart 2: Excel is a spreadsheet and is meant for quickly and easily doing complex calculations on moderate amounts of data.  However if you had a lot of data, such as a list of 100,000 names, then you would have to put that in a database like Access.  For most people, Excel is easier to use than Access, because Access requires you to understand tables, queries, and reports. Don't be fooled by the spreadsheet look of an Access table; it is a very different thing.
130036
1. Start Microsoft Excel\n\n2. Before you type fractions in cells, preformat the group of cells that need to be displayed as fractions. Select the cells where you want to enter fractions, and then select Cells from the Format menu.\n\n3. Click Fraction in the Category list, and then, from the list on the right, select the type of fraction that you would like to display. Click OK.\n\n4. Now you are ready to type fractions in these preformatted cells. To type fractions in cells, just type the numerator, followed by a slash (/), then followed by the denominator—do not type spaces.\n\na. For example, 1/2 would represent one-half, as would 4/8 (Excel reduces fractions to their lowest terms). If you need to type a whole number and a fraction in one cell, type the whole number followed by a space, and then type the fraction (numerator, slash, denominator).
811386
In Excel 97 (Must upgrade!) ... Format ... Cells ... Number ... Custom.\n\nSelect #.##0.00;-#.##0.00 and edit it to #.##0.00;(-#.##0.00) \n\nIt also saves your new format at the bottom of the list.
143192
Here's one way... there may be others....\n\nMake column A the "input" column (where you type in the # of days).  Make column B, C, and D "output" columns which displays the # of years, months, and days respectively.  Input the following formulas:\n\nCell B2:  =TRUNC(A2/365)\nCell C2:  =TRUNC((A2-(B2*365))/30)\nCell D2:  =MOD((A2-(B2*365)),30)\n\nHope this is what you are looking for...
231588
If you have MS Excel it's very easy. Go to the cell and set the format to be TIME 37:30:55. This format is HH:MM:SS.\nSo you can now enter your time in military time.\nPut your clock in time in one cell. Put your clock out time in the cell next to it. Since your clock out time will be a higher number you want to subtract your in time from your out time. For example: Time in 8:30:00 Time out (military time) 16:30:00, 16:30:00-8:30:00=8:00:00 8 hrs total. Now you can add up all the totals to find out a total for the number of times you worked. \n\nNow if you are wanting to convert time to a stander number and add that up to figure out the payment of your work week that is different. \n\nYou want to split apart the minutes from the hour. In one cell type in the minutes in a standard number formate ie 8:30:00 would be 30. Next you want to use the product fuction and mutlipy this number by 1/60. This result will happen: 30 X 1/60 = .5 \n\nNow place your your hour with this number 8:30 would by 8.5. This will work with any minute entry for example  43\n43 X 1/60 = .72\n\nGood luck with this.
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.
885824
The easiest way is to figure the number of minutes (to get them the same), then figure the number of hours (to get them the same).\n\nFor example, you need to move from 10:30 to 11:15...\n\nMentally move the hand forward from 10:30 to 10:35, then 10:40, then 10:45, etc.  You'll see that to get to 11:15 you have to move *9* five minute increments.  (9 x 5 minutes = 45 minutes).  So now you have made the minutes the same :15 and :15.\n\nNext you need to go from 11:15 to 1:15.  You can ignore the minutes now... you should count two spots from 11 to 12 to 1.  That's 2 hours.\n\nSo your final answer is 2 hours and 45 minutes.
371049
It's quirky, but you can do it...\n\nAll times in Excel are DateTimes, so you have to provide a day. Also, remember that the formatting is important.\n\nIn one cell, put "1/1/2006 9:00 am", in another put 1/1/2006 5:00 pm"\n\nIn a third cell, subtract the second cell from the first.\n\nNow it works, but it doesn't look right because its showing you a date as well as a time. Highlight all three cells, and go to "Format | Cells" and set the format to "hh:mm" Now the cells look like:\n\n9:00 am\n5:00 pm\n8:00\n\nVoila!
847912
Yep - many ways. In Excel, enter =NOW() in a cell and it gives the current time and date (copy - paste special - values if you want that 'stamp' to be fixed). In word, Insert - Date and Time, or Insert - AutoText - header & footer...\n\nAs a keyboard shortcut in Excel, press CTRL + ; for the date, CTRL + SHIFT + : for the time. In word, press ALT + I + T (press enter afterwards).\n\nHope this helps.\n\n(pressing F5 is WAY off the mark...!!!)
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
879627
Time math can be interesting... first, always convert the times to 24 hours:\n\n13:57 - 10:53\n\nNow it's just like math...  13-10 for hours, and 57-53 for minutes\n\n3:04 am or 3 hours and 4 minutes, depending on your frame of reference.\n\nHope this helps!
339223
Use the Median function.  Go to the cell you want the answer to appear in and type\n\n=median(xxxxx)\n\nwhere xxxxx is the location of the cells with the numbers that you described.  For example, if your numbers are in cells A1 through A7, your formula would look like\n\n=median(A1:A7)\n\nIf your numbers are in nonadjacent cells, you can separate them with a comma, like\n\n=median(A1:A4, A6:A8)\n=median(A1, B1:B5, C2)\netc.\n\nYou don't have to type the numbers (i.e. 10, 10, 20, 30, 30, 30, 30) in the formula - just use a reference (i.e. A1:A7) so that if you change any of the numbers, your median will automatically recalculate.
919760
Work in 24 hour times.\n\n10:18-16:23\n\n16-10 is 6 hours.\n23-18 is 5 minutes.\n\n6hr 5mins.\n\nFor an automatic way of doing it, visit: \nhttp://www.timeanddate.com/date/timeduration.html\n\nJust enter the hours and minutes, leave the days and months blank. It will accept 4pm or 16 as an entry for hours.\n\nYet another way, and good if you want to do them in batch. Use Microsoft Excel. Enter all the start times in 24 hours format in one column, and all the end times in 24 hour format in the next column. In a 3rd column, in the first cell type = then click the top cell in the 2nd column. now type - and click the top cell in the first column and hit enter. This calculates the first row. Now click on the result cell again, and you'll notice a box in the bottom right corner, hold and drag this (should get a + symbol) drag down to the bottom row, and it auto fills in all your formulas.
340306
Your function translates 0.340335648148148 to 8:10, but my function translates 8:10 to 0.3477777-ish.  The reason for this is because when the function above converts the time, it drops the seconds (and milliseconds, etc.).  Because of this, a level of precision is lost and the reverse function may not always yield the same value.\n\nGood luck!  E-mail me if you have any questions.\n\nThis should do it:  (You may need to tweak a bit for syntax)\n\nPublic Function HoursAndMinutesBack(interval As String) As Variant\n\nDim hours, minutes As String\n\ncolon = InStr(interval, ":")\n\nhours = Mid(interval, 1, colon - 1)\nminutes = Mid(interval, colon + 1)\n\nHoursAndMinutesBack = (hours / 24) + (minutes / 1440)\n\nEnd Function