Archive for the 'excel' Category

All I need is a worksheet formula so I can get the time difference between two given dates. I will be utilizing this worksheet to calculate employment times, gaps in employment…etc….please help. All input is appreciated. Can you please give me a formula to accomplish this task? Thanks!

Here is the story-> The Yankees and Rangers are both interested in righthanded pitcher Mark Prior, the onetime phenom who hasn’t pitched in the major leagues since 2006 because of repeated injuries. If the Yankees don’t get Cliff Lee, their next pitching target would be Kerry Wood, who excelled for the Yankees as a set-up [...]

Here is the story-> The Yankees and Rangers are both interested in righthanded pitcher Mark Prior, the onetime phenom who hasn’t pitched in the major leagues since 2006 because of repeated injuries. If the Yankees don’t get Cliff Lee, their next pitching target would be Kerry Wood, who excelled for the Yankees as a set-up [...]

I am fairly new to Excel Formulas, and need some help. I am creating a budget for my household, and I need a formula that will add up and show me the total of all bills. If this makes any sense – I need column F29 to equal the total of F12-28. Instead of typing [...]

Hi,,, I have three workbooks named “Master.xls”, “a.xls” & “b.xls”. I want to insert the sum of the cell A1 of “a.xls” & the cell A1 of “b.xls”. but that sum should be calculated in the cell A1 of “Master.xls”. I’ve successfully done the The Above mentioned. The problem is that now I want to [...]

I split the table in 2 parts, because it’s changing in here, just put them together (Ist part) …A……..B…C……D….………E…….…F 1.Prod..type.state.sumUSD.sumEUR.date 2.appl…fruit..co…..X1……….Y1…….… 3.carr…veg…ut…..X2….……Y2…….4-Feb 4.banan.fruit..ar…..X3.……..Y3……..5-Feb 5.potat..veg…ne…..X4………Y4…….22… 6..oran..fruit..oh…..X5………Y5….…2-Mar (II part) G…….H…….I….….J……..K…..L……M quart.pUSD.pEUR.date…quart.pUSD.pEUR I……..564….76…23-Feb..I……120……0 I……..85……0….1-Mar….I……0……..23 I……..0…….677..12-Mar..I……23……0 I……..0…….675..5-Apr….II……78……69 I……..87……0…..6-May..II……0……..88 I want to sum the payments in USD in D2, D3..D6, i mean D2 (X1) = H2+L2+P2+T2… (every 4th) and also [...]

1. Row 1 contains figures like 1,2,3,4,5,6,7,1,2,3 …… indicating Day of the week. 2. The objective is to Conditionally Format and highlight specific columns where Row 1 contains 6 or 7, i.e. Weekends.

I am doing a science fair project that deals with blood pressure, which is represented in what looks like a fraction. When I create a graph from my data, it converts the “fractions” into decimal form automatically, how do I keep the values in “fraction” form?

have hp compaq nx 7010 and i wanted to start again so i thought if i re-stalled windows it would wipe the whole computer,it worked, so then i tried installing word, Excel,powerpoint and all those programs and it said the c drive was full, i tried to format the c drive and i says windows [...]

The basis of the spreadsheet is to enter a run time in A1 – like 35 (for seconds it took to complete the run). I would like A2 to compute the rest interval based on the run time and give it to me in minutes and seconds. For instance – If Run 1 was completed [...]