In excell, how do you format the cells to calculate time?
478597
Ah, my bad, I misunderstood your question.  I don't think you can change the base of the numbers used by Excel (i.e., from base 10 to base 60).  There may be a few different way you can try to get around the issue, but that depends on how much flexibility you have in modifying the spreadsheet you need to do this for.  Just to throw out some ideas on the different calculations you can use...\n\nOne solution is to store the decimal portion as a percentage of sorts, where the unit is hours.  For example, you would have 4.30 to mean 4 hours 30 min, but you can store it as 4.5 to mean four and a half hours.  To figure out what the decimal portion is you would just divide the number of minutes by 60.  So say for 23 minutes, you would have the decimal be ".38", and that would mean 38% of an hour.  Thus anytime you would want to determine the exact number of minutes, just multiply .38*60 and round to the nearest integer (search for Excel's 'round' feature).\n\nYou could store hours and minutes in separate cells so you don't have to calculate anything to figure out the number of minutes.  You could also store the value as minutes only (4hrs23min being 263 minutes), the downside to that being that you'd have to calculate the hours and minutes every time you need them (by using 'mod' and 'rounddown').\n\nHope this helps.
745516
I'm not sure what kind of formatting you want to do, but In my experience the conditional formatting is set based on the result (value) of the formula, not the cell formula syntax (as it would if you set the cell format to be text, thus displaying the formula syntax instead of the result.  If you like, click my screenname and send me a message with more details and I will try to help.
763317
The easiest way if you use the default sheet names Sheet1, Sheet2 .... Sheet30 \n\n=SUM(Sheet1:Sheet30!A1) \n\nIf you use custom sheet names: \n\nInsert a new sheet before the first sheet and name it START. Insert another new sheet after the last sheet and name it END. \n\n=SUM(Start:End!A1) \n\nIf you will need to create any new sheets that should also be used in this calculation just insert them between START and END.
1005206
the same way you do it with excel...
830543
{=SUM(IF($A$2:$A$11 = DATEVALUE("11/29/06"), $B$2:$B$11, 0))}\n\nThis example (an array formula, so hit CTRL+Shift+Enter when you finish typing it instead of just Enter (don't type the brackets - { } )) sums the contents of Column B  for every instance the Column A contains 11-29). Just modify it to match your cell references and it should work just fine.
718467
go to the Format column, and then go to Cells...\nIn that box, pick TEXT. it will display your number exactly how it is written.
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...
326703
In Microsoft Excel, you can choose the type of number you want displayed in each cell.  \n\n-Simply highlight the cells you want to display this in\n-right click on your mouse\n-choose Format Cells  \n-Click on the Numbers tab\n-Scroll through the list until you find the one that is right for you.\n\nYou can also do this.  Say you want to convert 98% to .98,\n\n-Click on the cell you want .98 (i.e. B1) to appear in\n-Type: =\n-Click on the cell where 98% appears (for instance A1)\n-Type: * (the multiplication sign)\n-Type: 1.0\n-Hit return\n\nYour formula should look like this: =A1*1.0\n\nYou can then copy and paste this formula into any cell.  I hope this helps!
223758
I assume those are interval values and not actual times of day.\n\nTo average them, break them down into seconds, average the seconds, and then put that number back in HH:MM:SS format.\n\nIn this case:\n0:12:35 => 755 seconds\n0:02:10 => 130 seconds\n0:09:05 => 540 seconds\n\n(755 + 130 + 540) / 3 = 475 seconds\n\n475 seconds = 0:07:55
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.
832923
The default format for a cell in Excel is "general."  Someone at MS decided that big numbers "generally" should be displayed this way.  Go figure.\n\n\nRight click the cell\nSelect format cells\nselect number\nselect 0 decimal points\nclick OK
1107100
Select the cells that you want this special formatting applied to, then select the 'Conditional Formatting' option from the 'Format' menu at the top of your screen.\nIn the 'Conditional Formatting' wizard, select 'Cell Value Is', then select 'Equal to', and in the third box type the letter 'x' (or whatever value you want).  Then click the 'Format' button and choose the formatting effects you want applied when your chosen value is entered.  Then just click 'OK' until done.  Best of luck!
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)
1062293
I think its called conditional formatting. If value is cell b2 is greater than value in cell c2 then format cell b1 with bold color italics etc.
908613
1. Start with a new workbook and enter your task data as in Sheet1. Column A contains the task descriptions, column B contains the beginning date for each task, and column C contains the number of days to complete the task. Column D contains formulas thhat determine the ending day for each task. For example, the formula in cell D2 is =B2-C2-1. Column D isn’t really necessary (and is not used in the chart), but including it will tell you end dates easily.\n\n2. Create a stacked horizontal chart from the data in A2:C13. The Chart Wizard will probably guess these series incorrectly, so you’ll need to set the category axis labels and data series manually. The category (x) axis labels should be range A2:A13, the Series 1 data should be B2:B13, and Series 2 data should be C2:C13. \n\n3. Remove the chart’s legend and adjust the height of the chart so that all of the category axis labels are visible (or, change the font to a smaller size). \n\n4. Access the Format Axis dialog box for the horizontal (value) axis. Set the Minimum and Maximum values to correspond to the earliest and latest dates in your project. Note that you can\nenter actual dates into this dialog box. To display the dates at weekly intervals, set the Minimum to a Monday, the Maximum to a Sunday, and the Major Unit to 7. \n\n5. Select the data series that corresponds to the data in Column B and access the Format Data Series dialog box. Set Borders to None and Area to None. This essentially makes the first data\nseries invisible – and makes the chart resemble a Gantt chart.\n\n6. Apply other formatting as desired. For example, you may want to add gridlines and a title. You’ll be able to adjust your project schedule and the chart will update automatically. However, if you use dates outside of the original date range, you’ll need to change the scaling for the horizontal (value) axis.
925219
Ok This what you do. Micorsoft Excel Can do it for you perfectly well. All you need is to simplify the fomular inwhich you want to use in making your calculations so that everytime you type in a number you will get the totals without craking your head too much. \n\nExcel is what you need. \n\nThanks
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.