In Excel: Adding and subtracting hours to show times?
81780
TIME(HOUR(A1)+16, MINUTE(A1), SECOND(A1)) \n\nworked fine for me when I had A1 as\n\n="04:00"\n\n(Note the equal sign and quotation marks.)
894151
I think the way to approach this is to minimize the number of remaining (that is, unused) hours to zero.\n\nJob B jobs must be multiple of 10, e.g. 10 jobs = 7 hours exactly (no remainder). \n\nJob C jobs must be multiple of 5, e.g. 5 jobs = 127 hours exactly (no remainder).\n\nUsing this approach, if you did 60 jobs B and 10 jobs C, the hours = 60 * .7 = 42 hours + 10 * 25.4 = 254 hours, total = 296 hours exactly (no remainder).\n\nThis would yield a revenue of $10,465.24 \n\nWrong!\n\nHmmm - (I'm doing this in Excel with columns labeled:\n# of B jobs, # of C jobs, B hours, C hours, total hours, $B/hr, $C/hr, $B, $C, $total; then keeping total hours <= 296, what is max $total)\n\nBest answers using Excel:\n# of B jobs, # of C jobs, B hours, C hours, total exact hours, $B/hr, $C/hr, $B, $C, $total\n\n0,11,0.000,279.4,279.400,$35.51 $35.33 $0.00 $9,871.20 $9,871.20 all C\n\n422,0,295.400,0,295.400,$35.51 $35.33 $10,489.65 $0.00 $10,489.65 all B\n\n386,1,270.200,25.4,295.600,$35.51 $35.33 $9,594.80 $897.38 $10,492.18 \n\n23,11,16.100,279.4,295.500,$35.51 $35.33 $571.71 $9,871.20 $10,442.91 \n\n350,2,245.000,50.8,295.800,$35.51 $35.33 $8,699.95 $1,794.76 $10,494.71 \n\n314,3,219.800,76.2,296.000,$35.51 $35.33 $7,805.10 $2,692.15 $10,497.24 optimum\n\n277,4,193.900,101.6,295.500,$35.51 $35.33 $6,885.39 $3,589.53 $10,474.92 \n\n241,5,168.700,127,295.700,$35.51 $35.33 $5,990.54 $4,486.91 $10,477.45 \n\n60,10,42.000,254,296.000,$35.51 $35.33 $1,491.42 $8,973.82 $10,465.24 \n\nLooks like 314 B jobs and 3 C jobs win!\n\nI'm not sure how to put this in an optimization formula...\n\nHope this helps!
370400
This will depend on the software where you are doing your cutting and pasting. If it's a generic application like Microsoft Excel or Access you may be able to tinker with the settings. However for custom-designed programs, the software engineer gets to decide what is allowed to be pasted into the program from the clipboard. From your question it sounds like it's working in the morning but not in the afternoon? There may be a bug somewhere that cannot process the time once it gets above a certain value. You might be able to pinpoint the issue if you can determine that there is an exact time during the day when it stops working, then file a bug report with the software vendor.
366534
It completely depends on where you are using this formula, is it in Excel? A program? What language?\n\nWe need more info.
659401
correct the date,time,day in Ur clock
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!
890672
use the idea that \ntime/ work  rate = (1) job\nfor instance,,,,,the hot water takes 4 min to fill a tub\n1/4 * time = 1 job\nin one hour...1 * 1/4 --> 1/4 full\nin 4 hours...4 * 1/4  --> 1 tubfull\n\ntherefore the formula would look something like this\n\nt/4 + t/3 = 1\nmult by lcd\n3t + 4t = 12\nt = 12/7\nt= 1/ 5/7 min
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
432934
In excel all the cells are numbered - A1, A2, A3 as you go down the page or A1, B1, C1 etc as you go across the page.\n\nIf you have a list of numbers in cells A1 to A10 for example then to add them together you would enter =(sum A1:A10) in a different cell (lets say A11).  The result that was displayed in A11 would be the sum of the numbers in cells A1 to A10.  Note that only numbers can be added so if one of your cells contained an unrecognized format (e.g. a date or text) then it wouldn't be included in the calculations.\n\nYou can add up blocks of cells simply by changing the range.  If you look at your Excel spreadsheet and imagine date in each of the first 4 rows of the first 4 columns then the formula to total up these 16 cells would be =(sum a1:d4).\n\nYou can also use the method described above by clicking the cells you want included in the total - particulalrly useful if the values to be added are scattered across different rows and columns.\n\n------------------------------------\n\nAs regards inserting a page number you need to click on File > Page Set Up > Header / Footer and then either Custom Header or Custom Footer depending if you want the page number at the top of bottom of the page.\n\nDecide whether you want the page number on the left, center or right of the page by positioning your mouse pointer in the corresponding box and then click on the second of the 2 icons - it has a symbol like this on it... #\n\nYou can add text before and after the page number so that your sheets could, for example, read 'Page 1 of 7' 'Page 2 of 7' etc.
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.
18386
Are those times?  As in, one hour, 24 minutes, and 43 seconds?  In that case, I would say that 1:24:43 minus 1:22:05 is 0:02:38.  You come up with this answer by subtracting the first numbers (1-1), then the second numbers (24-22), and then the third numbers (43-05).  This way, you're subtracting hours from hours, minutes from minutes, and seconds from seconds - they have to match up.
1164923
yahoo widgets has a clock that would do what you want.\n\nthe Floresense WorldClock widget lets you add multiple cities to the widget and it shows the current time in each.
22801
add 2 hours to 11 o'clock and it becomes 1 o'clock
278941
Not sure if you want something this simple, but check out www.Quickbooks.com or www.peachtree.com.\n\nSage software also has some popular time and billing systems. I think one is called Timeslips and one is called Time Matters.
628315
The time that you have is not a time but is a string.\nUse the time() function.\nie. time(9,15,0)
772358
the example you gave is misleading.\n\n1.30 hours( 1 hour and 20 minutes) = 78 minutes \n78 * 5 = 390 minutes\n390 minutes /60 =6.5 hours\n\n1.50 hours( 1 hour and 30 minutes)=  90 minutes \n90 * 5= 450 minutes\n450/60 = 7.5 hours\n\nif the decimal represents number of minutes then you've got\nsome conversion/manipulation to do.\n\nuse the modulus function to extract the decimal part.\n\nmultiply by 100 to get the number of minutes.\n\ndivide the result by 60 to get the decimal equivalent of minutes.\nie\nminutes=(1.30 mod 1)*100\ndecimalminutes=((1.30 mod 1)*100)/60)\n\nthe fix command returns the number without the decimal,\nand no rounding\nie\nfix(4343.99) returns 4343\n\n\nsooo - using your example I'd convert everything to minutes\ntrueminutes=((1.3 mod 1)*100) + (fix(1.3) * 60)\ntruminutes=90 \n\nthen I'd multiply (or add up) the numbers \nsince it's the same hours for mon - fri, I'd just multiply by 5\ntotalminutes=trueminutes * 5\ntotalminutes=450\n\nNow, I'd divide by 60 to get hours\nhours=totalminutes /60\nhours=7.5
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.