Is there an easy way, or formula to add hours?
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.
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.
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.
1003654
Midnight is zero hundred hours, count from there up to 24. For instance 8am is 0800 hours, 2pm is 1400 hours, 9pm is 2100 hours, etc.\n\nTo your additional details, it is because you worked eight and a half hours. When calculating work hours, it is easier to add your hours that way. Eight and a half hours is 8.5 hours. If you worked until 2:15pm, it would be written as 8.25 hours.
691740
Try this:\n\nHold MODE and SET for 2 seconds. Then use MODE and SET to adjust hours and minutes. Hold them again to exit adjust mode.
52451
10 Hours\n10*7 = 70 Hours \n10*7*4 = 280 Hours
1071550
Time: if it's 2 o'clock and you subtract two hours it goes back to 12 o'clock ;)
713684
Try this:\n\nAnnualized hours / Number of work days in pay period =\nPer diem hours * Actual number of days to pay * Hourly average = Dollar amount of pay
883420
=A1+B1 for cells \nand for columns you could do \n=SUM(A1:A10)\n\nrows could be \n=SUM(A1:f1)
791300
Use the FOIL method; First, Outer, Inner, Last.\n\nFirst, n * n\n\nOuter, n * 5\n\nInner, n * 7\n\nLast 7 * 5.\n\nThen add them all together.\n\n22 NOV 06, 0420 hrs, GMT.
105308
its easy to do\n\ntype your names down one column, and the teams across the top\n\nat the end where you want to total just put in the formula =sum(b2:E10)
653602
Do you have Excel, if you do, then Excel can do that.  I think the formulas are self explanatory but if it isn't obvious to you, a Google search should turn up on how to do this in Excel.
888634
9 hours + 7 hours is 16 hours. \n\n$116 divided by 16 hours is $7.25
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...
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
863996
tell him/her to subtract the minutes first.they should end up with 7:55. then have them subtract 3 from 7
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...!!!)