how will calculate time difference in excel for making overtime sheet?
829485
You can use what i did\nUse a formula to devide the time stamp into hours and minutes like this\n=HOUR( B4)-HOUR( A4)+(INT( MINUTE(B4 )-MINUTE(A4)) /60)\nAssuming that A4 has the start time, B4 has the end time.\n\nIf you have two times in differant days, that is another story, mail me here in Y! Answers for it\n\nEnjoy my profile, I am the VBAXLMan
401014
What you need to do is enter the beginning time and ending time in 2 different cells.  Highlight all the cells that include time and click Format in the standard toolbar.  Then click Cells, when the window opens select the Format tab and chose the Time option in the right.   Select the time format that works best for you and click OK.  Then type the formula and make sure that that cell is also formatted as a time type cell.  If you are just calculating how long people are working a simple B-A forum la would help.
630142
Set up a loop like this:\n\nExitFlag=false\nDo\n   Range("B8") = Format(Now(), "HH:MM:SS")\n   DoEvents\nLoop Until ExitFlag=true\n\nThe point of my variable ExitFlag is that you might want to break out of this loop at some point.  You could set this variable in a macro for pushing a Cancel button - if needed.  You don't have to have it though, you could just use Do... Loop\n\n(A more efficient way is to link this to some kind of system timer event, but I don't know how to do that in Excel.)
943817
[EDIT - DELETED A WHOLE BUNCH OF TEXT]\n\nthat kind of thing is complex to create in a macro form, normally the kind of thing that you'd pay someone to do because i'd imagine it's easily a couple of hours work to write all the code, test it, iron out bugs etc. there *may* be a built in function in excel to do something like this but i wouldn't have thought so - i'm happy to be proved wrong:\n\n----found on t'internet----\nA1:A10 (your list of values)\nB1:B10 (leave blank)\nC1: =A1*B1 (copy thist fomula down through to C10)\nC11: =SUM(C1:C10)\n\nNow to use Solver....\nTools>Solver\nSet Cell: C11\nEqual to the Value of: 1173.76\nBy Changing Cells: B1:B10\nSubject to the Constraints....\n(click the add button and constrain B1:B10 to Binary)\nClick [OK]\nClick [Solve]\n\nExcel will toggle cells B1:B10 between 1 and 0 until it comes up with a combination that sums to 1,173.76\n----end of instructions----\n\nit depends on the setup of your spreadsheet - if it's one huge page that's a jumble of undistinguishable invoices with no reference to who the invoices belong to, it means manually checking the results of the macro for the set of results that applies only to one 'customer'. ideally you'd want a seperate sheet for each customer and then the macro or above method can be ran on whichever sheet/customer the cheque is from.\n\ni dunno about other people on here but i wouldn't spend hours of my time creating such a thing for the sake of 10 points which aren't really worth anything - i CAN tell you that if the above method doesn't do the job that it'd mean creating a loop that will add up every possible combination of totals from the sheet then comparing it each time against the grand total until it gets a 'hit'.\n\ni can't imagine this kind of sorting being practical for huge amounts of figures, probably a list of 20 at most because you could get into some big big processing time otherwise.\n\ni would be interested in hearing anyone elses ideas about doing it?
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
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.
1176830
well 3hrs 20 minutes is converted just like you do 3hrs 30 minutes. 20 divided 60 = .33 so it would be 3.33 hrs
556307
I think what you're looking for is the "equation of time", which is the difference between local mean time and local apparent time.  The term "difference" is used because "variance" has a very specific mathematical meaning.   Local apparent time is determined by the position of the sun in the sky.  local mean time is based on Greenwich Mean Time.  The difference occurs because GMT is based upon a fixed rotational rate, and local apparent noon is determined is by the maximum altitude of the sun in the sky.\n\nThe two time scales differ by as much as 15 minutes.  The web page below has more details.\n\nThere are formulas for this, but they are complex calculations.  The equation of time changes constantly, although the change is very slow, so a graph of the difference in 1980 is still mostly correct for 2006.  You'll be accurate to within a few seconds.
18778
I think you are refeering to Yahoo time, You can check the difference in the time based on the timestamp on the answer ;-)
1075834
a)7:30 + 3:42 =  11:12    Just add minutes it gives 72 but sixty minutes is an hour so 72 = 1 hour and 12 minutes keep the 12 in minutes section and carry 1 hour to hour section.7+3 =10\nAdd carry 1 you get 11.\n\nb) 18:30-3:42 =   14:48  ...Proceed similarly this time you need to borrow 1 from hours section that becomes sixty minutes subtract 42 from 60+30\n\nc)3+42/60 = 3.7 hrs\n\nd)370/3.7= 100 km/hr
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.
771544
I am not sure I completely understand you question.  I think you are trying to determine how to calculate overtime.  Try this:  http://deskinlawfirm.com/calculate_your_regular_rate_for_overtime_purposes
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.
325793
As per my timecard cheat sheet:\n\n0-3 min = .0\n4-9 min = .1\n10-15 min = .2\n16-21 min = .3\n22-27 min = .4\n28-33 min =.5\n34-39 min = .6\n40-45 min = .7\n52-57 min = .8\n58-60 min = .9\n\nThese are only for a tenths system, however if your system goes to hundreths it maybe slightly different.  The best way for you to know for sure is check if your place of employment has a policy on this.
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!
414725
t=time it takes in hours to do the job\nSusan does half the job in an hour\nJaime does a third\nThey have one job to do\nso 1/2t+1/3t=1\nfinding like denominators, we get\n3/6t+2/6t=1\n5/6t=1\n5t=6\nt=6/5\n\nThat's roughly 1 hour, 12 min
1006215
Use the formula d = rt (distance = rate * time)\n\n1) Train A: d = 40t\n\n2) Train B: d = 60(t - 1)  [left an hour later]\n\nthe answer is when the two distances are the same, so we set the two equations equal to each other\n\n40t = 60(t - 1)\n40t = 60t - 60\n60 = 20t\n3 = t   [3 hours]\n\nPut this result back into equation 1\n\nd = 40 * 3 = 120\n\nAnd we expect the same result in equation 2\n\nd = 60(3 - 1) = 60 * 2 = 120\n\nI provide this level of detail in case you need this level of help.