Hi All,
I'm trying to sum fractions (#/#) to get an overall percentage, and am having some trouble with it.
Here's a quick example:
Row 1 2006 2007 2008 2009 | (desired outcome)
Row 2 0/1 0/0 1/1 0/1 | 1/3
Row 3 0/0 0/0 0/0 0/1 | 0/1
Row 4 1/1 1/1 1/1 1/1 | 4/4
Row 5 0/1 0/1 0/1 0/1 | 0/4
Basically, I am trying to calculate participation (numerator) over whether they had the opportunity to participate (denominator). The column above, "desired outcome" is what I want these fractions to add up as (but am currently having trouble with). Basically, I would like to separately sum both numerators and denominators as an aggregate fraction (percentage would work, too). Similar to a basketball player's shooting percentage over the course of different games. The COUNT and SUM functions have been useless thus far.
Thanks!!
My better half has asked for my assistance in constructing a table that would reflect the time differences between locations in different parts of the world (based on military time). I’ve been able to partially accomplish this by making use of Excel’s “Time” function as indicated in the example below. When I add time to the (EST) the function performs quite well. However, when the function encounters negative numbers, (time zones that run behind ours) it runs into problems. Any assistance would be greatly appreciated.
Chuck
US
(EST)
TIME Difference
(in hours) Local
Time Function
22:00 6 4:00:00 AM =A2+TIME(B2,0,0)
15:00 -1 #NUM! =A3+TIME(B3,0,0)
I have a formula that multplies a weekly hire rate by the number of days. This produces figures that have fractions of a penny that are not shown on the sheet. When I autosum these figures, it adds up all these fractions of a penny, and the resulting total does not then appear to agree.
Any suggestions for a quick fix gratefully received.
Thanks Pablo1
I am trying to do a strange ways of adding, like if cell is a1=500, b1=500,
c1=500 then on cell f1 has column down to f5 with formula like first cell
f1=65, f2=100 on down to f5, then next roll over g1 to g5 has formula of
subtract of f1 from a1 which is 435, then g2 has f2 subtract from a1 then its
335, now ? is if g4 show 0 or -0 I want it to pick up b1 from a1 and keep on
subtracting till last cell is completed like g5 is last cell with out going
pass 0 or -20
I was hoping you guys could help me.
I have this time sheet which keeps track and tells me how many hours it takes to do specific things. On the bottom i have buttons that my people push when they are stop on a cirtain project and when they start back up. Now when they have put in there stop time at the top of page it totals up the hours. I need the bottom colum to add or subtract the amount of time they were not on the panel.
When they are over in time the total hours is red. When they are under in time the total hours is green.
I hope i explained it well enough if there are any questions feel free to ask.
Please heeeelpnvagle@epgco.com
I need help with adding and subtracting times. Our vacation is based on 1.54 hrs / week and I would like to keep track of this. How can I do this? When I take a 8.0 hr vacation day and then add back my 1.54 hrs received.
Good day...
How can I add or subtract 12h to a field that contains a time in hh:mm?
Thanks folks.
Is there a formula for this:
In B2 there is a value, such as 1,500,000
In B3 is where I want the sum and the formula
In A3 I would like to be able to enter a percentage such as 4% but I could change that percentage in B3 if needed and it would make the the change in the calculation. Say change to 5.5%
So then I could produce a sum total in B3 such as minus 4% of B2.,
(1,500,00) minus 4% is what would calculate in B3...
If this is possible I would like to have the same scenerio but using plus 4% instead of minus 4% in another formula and cells.
Thanks for any assistance.
I was hoping you guys could help me.
I have this time sheet which keeps track and tells me how many hours it takes to do specific things. On the bottom i have buttons that my people push when they are stop on a certain project and when they start back up. Now when they have put in there stop time at the top of page it totals up the hours. I need the bottom colum to add or subtract the amount of time they were not on the panel. I need them to do either or depending on if the are over or under in time.
When they are over in time the total hours is red. When they are under in time the total hours is green.
I hope i explained it well enough if there are any questions feel free to ask.
Please heeeelpnvagle@epgco.com
Hello
I have a multiple tabbed WB
In cell(s) G4 I have =Now() with the cell formatted as dd/mm/yyyy hh:mm this gives me the current system time, for example 25.06.2008 08:16.
In cell(s) G5 I want to display time differences + or - if however I put =G4+4 it advances the day by 4 days but I want to advance the time.
Any ideas please
Thank you
