in excel how do you get the thing to add up hours?
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!
347042
I just looked up the Add On.  It looks very good.  I know what might be your problem.\n\n(1)  Click on the cell to edit the formula.  \n(2)  Press Ctrl-Shift-Enter\n\nStep 2 will insert the {} which you need for an array function.  If this does not help not sure what the problem is without seeing the entire formula.
969504
Yes there is a formula for working it out. They do not actually remember every date and day. I have it in one of my books, I'll find it and add it here later.\n\nHere's a link to site that does the calculations.\nhttp://216.109.124.98/search/cache?p=how+do+i+work+out+what+a+day+of+the+week+was&prssweb=Search&ei=UTF-8&meta=vc%3D&fl=0&fr=ush-ans&u=www.nightmare-relm.co.uk/guest/birth.php&w=work+day+week&d=VgBk9JIFNyTS&icp=1&.intl=uk\n\nI'm still checking my books for the formula\n\nRight I'm back. I've found the answer. I\nYou have to memorise a lot of codes for different days and  months. It's too complicated to write here and I'm not sure that so-called "mindreaders" would be too happy if I gave away the secret.\n\nYou can by a CD with instructions on how to do it.\nhttp://www.world-of-magic.co.uk/magic.asp?id=16568\n\nSorry I couldn't be more help
964099
Just go to the Cell that you want the total in.\n\nType +sum(d2..d6) where d2 = your first cell to be added and d6 = your last cell to be added.\n\nYou could also use the AUTOSUM button on the top toolbar.\n\nHighlight the cells you want added and hit the button.\n\nHover your cursor over the buttons till you find it.
1109073
Assume you have only A1 to A10 contain a number of 1,2,3 and B1 to B10 contain the # of days\nput this anywhere, say B11\n=SUM(IF(A1:A10=1,IF(B1:B10>2,1,0)),0) \nyou will get #VALUE!\nthen keep your cursor stay at B11, hit F2 then Ctrl+Shift+Enter to make it an array formula, the above formula in B11 should be in brackets { }.\nTo clarify a few points in above formula...\nin the formula the A1:A10=1 is your criterion - only 1 not 2, not 3\nthe B1:B10>2 is also your criterion - over 2\nthe last 1 in the formula is if the 2 criteria on each row are met, add 1
930497
find the standerd formula, rearrange it, and plug in the numbers
684057
Go to programs, new.  Type in the formula and save it as a program.  When you need the formula just go to program and then edit and you can see the formula
20263
If you have Microsoft Excel, then put in the following formula:\n\n=NOW()-45\n\nI just did this, and it displayed 10/25/2005 with the current time.\n\n---\n\nImproved answer:\n\nIn Cell A1, put the date the invoice was due (like 10/1/2005)\n\nIn Cell A2, put \n=now()-a1\n\nThen format Cell A2 as General (by clicking on cell A2, and choosing from the Menu "Format/Cells" and then clicking "General")\n\nIn A2 will be displayed the number of days late that this invoice is.  For example, if I put in 10/1/2005 into cell A1, I see in cell A2 "69.60569711" meaning that they are more than 69 days late.\n\nWe can make this answer as complicated as you want!
1033780
Use the help available in excel. They provide a detailed explanation with examples.
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
22801
add 2 hours to 11 o'clock and it becomes 1 o'clock
252390
I'm going to e-mail you an Excel spreadsheet that will do it.   Don't change anything except the dates and the yellow cells and everything else will automatically calculate.
718295
It is on your last grade card.  Multiply your hours times your grade value, add them all up, then divide the total by the total number of hours taken.\n\nA = 4\n\nB = 3\n\nC = 2\n\nD = 1 \n\nF = 0
1120124
Not sure if this is what you mean, but ...\nCreate an Excel sheet,\n\nRow 1 is the titles, in this order\nDate, Value, Sale, Month 1, Month 2, ... Month 6, Month 7, Sale Total, Accumulated Total.\nYou can use whatever titles you want.\n\nIn Row 2,\nLeave Date and Value blank.\nIn Sale, type '=B2*0.045',\nIn each month, eg, Month 1, Month 2, etc, type '=B2*0.025'\nIn Sale Total, type '=SUM(C2:J2)'\nIn Accumulated Total, type '=SUM(K2)'\nSelect the columns, C2 to K2, then grab the little square in bottom right hand corner of the selection you just made.  Hold you mouse button down, go down the page to how many entries you want.\n\nThe only thing you will have to do manually, is to update the Accumulated Total column.\nRow 3, =sum(k2:k3)\nRow 4, =sum(k2:k4),  etc
778758
.\nI understand.  Am in the same boat...just getting back to work after many years.\n\n1.  Open Excel\n2.  Enter data in cells\n3.  You must highlight all cells you want totaled.\n4.  To highlight click the first cell you want added > then hold down keyboard SHIFT key >\nthen click below last cell, in an empty cell where total will appear.\nYou may total several columns at the same time.\nTo total a row, drag across the row.\nIn above tool bar click the "sum" button\n(it looks Greek like a backwards E\n\n5.  To see the formula Click in cell where the answer appears and look above  \n\n6.  You will see the "sum formula" in the long white  text box for "Insert Function"\nIn that text box you can type in and can change your formula for the area you want it to cover by changing the formula to\none column \n[example]         =SUM(A1:G1)\none row\n[example]         =SUM(A1:A8)\nseveral columns\n[example]          =SUM(A1:G8)  \nThe first number is the first column/cell\nthen a colon\nthen the last number is the last column/cell\n\nNow for other help remember the Office Assistant is totally cool.  It even helped me at exam time, hee hee.  Click on the question mark on the above tool bar, and when the "assistant" appears type in your question.\n\nGlad to help\nstw\n.
844854
I know how to do the number of days if that helps.\n\n=DAYS360(B2,C2,FALSE)\n\nCell B2 has the start date and Cell C2 has the end date with the formula in Cell D2.\n\nOK the month is =MONTH(C2-B2) but it will give you a result of 11 as it rounds to the nearest number.
47323
If you just type January into the first cell, you can click and drag on the small black square in the bottom right of that cell and Excel will automatically fill in months for as long as you want to keep dragging.  This will work either across or down.