I have a spreadsheet with start and end times for people's working day, in 24 hour format. So it will be 830, 900, 1030, 715 etc in the start column and 1700, 1715, 1550 etc in the end column. I would like to do a calculation on these times to work out for each person how many hours are in their working day (including lunch and breaks). At the moment Excel regards these as regular numbers, so I cannot do a calculation like 1700-830 because it won't come out right. I have tried fiddling with the cell format with no success. How do I do it?

I have a balance column that I want to only display the results after the
calculation has been completed. I don't want to see the zeros or the last
result all the way down the column

=?Utf-8?B?TGVhcm5pbmc=?=

=?Utf-8?B?TGVhcm5pbmc=?=

I'm trying to take cell A1 and subtract it from cell B1
and if the two cells equal then input text in cell
C1 "Balanced", if the two cells do not equal then input
text in cell C1 "Out of balance by (what the actual
difference is)". Does anyone know the formula to use?
Thanks

Mike

Mike

I need to be able to calculate a commission as follows:
Total Amount=$500
Total Commission (0-$100, 5%)+($101-399, 10%)+(>$400, 15%)
This would calculate a different percentage for each of the ranges
above and then add them together. I hope I'm making myself clear
because I'm confused just writing this.
It seems like there should be a very easy way to do this in Excel.
Any assistance would be most appreciated.
Thanks,
Andy

Andy

Andy

I have sales and salespeople for three years (2004, 2005, & 2006). I have
set up a calculated field to generate average sales per sales person. Next,
I set up a calculated item to generate a % change from 2004 to 2005 (and a
second calculated item to do the same from 2005 to 2006).
In my calculated item, the results are accurate for sales and the number of
sales people.
For my calculated field, however, the percentage is way off. I can't even
figure out what, exactly, is being calculated.
Is this a pivot table limitation, or am I missing something.
Please advise. I'm using MS Excel 2003.
nick

=?Utf-8?B?cm9ndWVfYWN0dWFyeQ==?=

=?Utf-8?B?cm9ndWVfYWN0dWFyeQ==?=

In one colum I have different years eg. 2009, 1979, etc.. In the next column
I have 2010. What I'm trying to do is subtract from each colum to show how
many years a person has been in employment eg. 2009 joined company 2010 left
company. I know I can do =2010-2009, but how do I drop the formula. I have
tried putting in the colum eg. =a-b, but this doesn't work. If I do it the
other way I have to do it individually.
Can anyone help?

=?Utf-8?B?S1RDNTM=?=

=?Utf-8?B?S1RDNTM=?=

While performing calculations amongst cells / rows,
the "sum/result" of such calculations (majority of the
time) are incorrect by a few pennies / digits. Why???
Is there a way to make all cells consistent and
either "round-up" or round-down"? Could this be my
problem??

Dane

Dane

I am looking to compare actuals to budgeted amounts.
The actuals are real $. The amount budgeted was $0.00. I need the
percentage over. What formula can I use to get the % over budget in Excel?

=?Utf-8?B?Q2hyaXN0eUI=?=

=?Utf-8?B?Q2hyaXN0eUI=?=

Hello, as a preface; the calculate option in Tools is set on automatic
I built a large spreadsheet six weeks ago that has worked perfectly until
today. the sheets that contain VLookup formulas that reference data in
adjacent sheets.
The cells with the VLookup's won't claculate unless i place the cursor into
the cell (as if to edit the formula) and hit the enter key. then the formula
works, but only that cell. F9 does nothing. Restarting does nothing.
Does anyone have any ideas?

=?Utf-8?B?SW5kaWdvIEJveQ==?=

=?Utf-8?B?SW5kaWdvIEJveQ==?=

Does anyone know how to calculate age from using the
persons birthdate? I would do it by hand but I need to
calculate over 1500 employees!

Corrine

Corrine

Hello
I have 3 workbooks linked together in this order
2 linked to lookup 1 database workbook of 1 worksheet
then 1 of the 2 others linked to the other. These 2 have multiple
worksheets with lots of formulae in each for comparing price results
at Tender and Completion of a large Construction Project to prepare a
line by line Claim for Extras for Variations.
My problem is, that when I load the last big workbook, "Calculate"
appears in the Status bar at the bottom of all sheets in all open
workbooks, even though Calculation is set to Auto. To allow me to keep
working, I have to set Calculation to Manual with provision to
calculate each workbook prior to Saving. (this wastes a lot of time
and is fraught with lurking disasters...I've had a few Excel crashes)
Using Office 2000 Excel on Win 98SE (locally) on a Pentium 500 with
256mB Ram, floating Swapfile and all the files are on our office LAN
Server.
Is there some limit to what Excel can do before it chokes down or
should I be looking for some other glitch in the setup of the
workbooks?
-- Reader to complete...
-- Please reply to this ng as my email adress is fake:
-- Regards
-- CC

Clarence Crow

Clarence Crow

Hi
I have 28-Jul-05 15:40:11 in cell D3 and would like to calculate the
period remaining until it is reached. I tried using NOW in another cell
and subtracting them but "VALUE" is always returned.
Is there a formula to return it in DD/MM or DD/MM/SS ?
TIA
Tim

=?Utf-8?B?VGltIE1pbGxz?=

=?Utf-8?B?VGltIE1pbGxz?=

hi everyone.
is there any way to stop Excel from calculating a spreadsheet once it has
started?
TIA
big t

=?Utf-8?B?YmlnIHQ=?=

=?Utf-8?B?YmlnIHQ=?=

I know you have probably answered this question before but here it is again.
I have a document that I am trying to make easier to fill in (weekly we have
to make upwards of 182 different documents).
I have seven fields that I need to put the dates into starting with monday
and ending on sunday. Is it possible to enter monday's date in the first
field and Excel enter the next six days including it the last few days of
the month and it makes that adjustment.
Basically it looks like this:
Monday Tuesday Wednesday Thursday
Friday Saturday Sunday
(A,8) (C,8) (E,8)
(G,8) (I,8) (K,8) (M,8)

Donald

Donald

I'm trying to calculate mixed formats like currency * time
If I worked 9:22 today and my hr rate is $23.00/hr
how do I do this?
Mark

Mark

Mark

I am trying to duplicate the results found on a real estate website that
shows the equity buildup over a period of 20 years based on purchasing a
$200,000 property every two years which appreciates at 5% with a 10%
down payment. Every 2 years you would take an equity loan of $20,000
from the previous property to purchase the next. The calculation also
seems to take into account the amount of equity gained by paying down
the loan. The numbers that are used in the calculation are:
Code:
--------------------
200000 Initial value
5 % Rate of growth
7 % Annual interest rate
10 % Down payment
0 % Misc. expenses, ie closing, fixing, holding
20000 Total investment
2 Number of years between reinvestments
--------------------
The results of the calculation are:
Code:
--------------------
Results
Time years Net Equity
2 $44,289.09
4 $98,076.20
6 $217,185.30
8 $480,947.01
10 $1,065,035.38
12 $2,358,472.64
14 $5,222,730.91
16 $11,565,501.21
18 $25,611,278.93
20 $56,715,017.95
--------------------
I�m no expert at real estate formulas but I do think of myself as
pretty good at it and I�ve written a number of formulas and
calculations that prove out certain theoretical returns but this one
has me stumped. The website itself is
http://www.taxloopholes.com/PUBRealEstate.asp?Calculate=y#calc
--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16578
View this thread: http://www.excelforum.com/showthread.php?threadid=395192

JimDandy

JimDandy

Annual Controbution $3000 Rate of Return 3% Years of contribution 5 Years.
How do i calculate the amount saved

=?Utf-8?B?YmFv?=

=?Utf-8?B?YmFv?=

I would like the pivot table to show three computed calculations, like:
Length
Avg St Dev Count
Type 1
Type 2
Type 3
etc.
Is there some way to do this in one swell foop, or should I just create the
pivot table three times, and copy the data to a new worksheet?
Thanks in advance.

=?Utf-8?B?cGRiZXJnZXI=?=

=?Utf-8?B?cGRiZXJnZXI=?=

I am a recent convert from PC to Mac and have been generally pleased
with Microsoft Office for Mac - until now.
I am running Microsoft Excel 2004 for Mac, Version 11.3.6 on an Intel
Macbook Pro, OSX Version 10.4.1.
I have two files each containing roughly 5,000 records. File A
contains a vlookup column that references File B. The lookup is
ridiculously slow. Further, simply having File A open causes all
other functions in other excel files to be ridiculously slow.
Just for yucks, I ran the same files on Windows Excel 2003 (same Mac
machine using parallels) and got a good response.
Am I missing something or is Excel for Mac inherently slow?

danyoung02

danyoung02

I am entering payroll hours into a spreadsheet. For
example, time in 8:55am, time out 10:40am. Is there a
formula to calculate how much that time comes to?
Thanks in advance, Janet

Janet

Janet

Hiya guys,
Im new to this forum, but hopefully I will be able to help out with
questions where ever possible
I do have a querry regarding a pivot table though.
Does anyone know if it is possible to create an if statement within the
creation of a field?
I can do simple calculations like field1 * field 2
But unfortunately I am getting a div0 error displayed and i need to do
an if statement to kill of it
--
Atom290
------------------------------------------------------------------------
Atom290's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14827
View this thread: http://www.excelforum.com/showthread.php?threadid=264586

Atom290

Atom290

I was wondering if anyone could help me with an error when I try to
count scores that fall between a 0% - 67% range. If I leave it as 0%
it does not count the cell. If I change the formula to 0.1% - 67% then
it counts it. Any ideas?
Here is the array in question:
=SUM((I$6:I$28>=0.1%)*((I$6:I$28<=67%)*((C$6:C$28="Asian"))*1))
I need it to accept the 0.1% as 0%.
Thanks,
Tobro
--
Tobro88
------------------------------------------------------------------------
Tobro88's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28895
View this thread: http://www.excelforum.com/showthread.php?threadid=490591

Tobro88

Tobro88

This one's got me:
Trying to calculate "begin cooking" time based on length of a foods
cooking time until done, and desired done time.
IOW. . .
Need a chicken done at a certain time, lets say 5:00 PM
It takes chicken 3-1/2 hours to cook.
Am lookin for formula and formatting to calculate and return 1:30 PM
in the "begin cooking" column (based on 3-1/5 hour cooking time)
(Will eventually include additional food items each with different
cooking time length, and desired done time..) Looking for desired
"begin cooking " time.
Thanks for any suggestions.
Peter

cowguy

cowguy

I want to set calculated values on a sencondary axis in a simple
linediagram.
On the left side of the diagram the axis values are
100
50
0
-50
-100
On the right side I want to set my calculated values, for example
10
125
infinite (correct ???)
-125
-10
at the same position as the left.
Any idea, how I can solve this problem.
Thanks.
Henning

Henning Winkler

Henning Winkler

Sometimes when I enter a formula in a cell, it displays the textual formula instead of the result. (Usually this is a Summation). Re-entering does not correct the problem but I can usually find a workaround by using an adjacent cell or using the long form (e.g. a+b-c...). In other cases, the result does appear but isn't included in a calculation of the entire column. Does anyone know what causes these problems and/or how to fix???
thanks,
oldgene

=?Utf-8?B?b2xkZ2VuZQ==?=

=?Utf-8?B?b2xkZ2VuZQ==?=

My data looks like this:
Store# Date Freq. of Dates
1 10/2/2006 2
1 10/2/2006 2
2 10/2/2006 2
2 10/1/2006 1
2 10/2/2006 2
3 10/5/2006 3
3 10/5/2006 3
3 10/3/2006 1
3 10/5/2006 3
I want to insert a new column that will pull in the date for the max of
Freq. of Dates for a given store, which in essence gives the mode date for
each store. I would like my data to look like this.
Store# Date Freq. of Dates Mode Date
1 10/2/2006 2
10/2/2006
1 10/2/2006 2
10/2/2006
2 10/2/2006 2
10/2/2006
2 10/1/2006 1
10/2/2006
2 10/2/2006 2
10/2/2006
3 10/5/2006 3
10/5/2006
3 10/5/2006 3
10/5/2006
3 10/3/2006 1
10/5/2006
3 10/5/2006 3
10/5/2006
I've been scratching my head about this one for awhile and can't come up
with a solution. Can anyone help? Perhaps there's an easier way to get the
end result I'm looking for without even using the Freq of Dates field. What
I'm really after is the mode Date.
Thanks

=?Utf-8?B?Z29vZnkxMQ==?=

=?Utf-8?B?Z29vZnkxMQ==?=

Hi
Can any one help me how to calculate Loan Payment Dates and re payment
amount using following parameters (Loan amount, rate, start date, Frequency?)
Frequency - Monthly, Weekly, Biweekly, Bimonthly
I am trying to populate data as below:
Date - Payment Recd - Payment Due - Total Paid - Balance Amount
Thanks
Vinod

=?Utf-8?B?Vmlub2QgTWFoZW5kcmFrYXI=?=

=?Utf-8?B?Vmlub2QgTWFoZW5kcmFrYXI=?=

I am looking for a way to have a summary workbook and multiple identical
layout subbook that will automatically be included in a formula withough
having to change the formulas when a new subbook is added.
Example: Master Summary Workbook, and 3 Salesrep books. Then i hire
another rep. I want to duplicate the rep book and have it included in the
formulas. I have some 2,000 formulas in this sheet and i dont want to have to
recreate it all the time.

=?Utf-8?B?Q2hhZA==?=

=?Utf-8?B?Q2hhZA==?=

can anyone help me calculate the amount of different caratage of gold.
For eg: 18k, 20k, 22k, etc
thanks

Kamlesh L. Makwana

Kamlesh L. Makwana

Hi,
A simple calculation formula result is not displayed correctly.
Formula: "=3+3"
Expected result: 6
Displayed result: 0
This failure occurs only in one particular sheet among all the sheets
of a workbook.
If I select the formula from the formula bar and click F9, I can see
number 6.
But once I come out of the cell by clicking ESC button, the formula
displays number 0.
Several trials have been made to get the expected result.
Trial 1: Tools >> Option >> Automatic (calculation option) selected
Trial 2: F9 key clicked
Trial 3: Ctrl+Alt+F9 keys clicked
Trial 4: F2+Enter keys clicked on the formula cell
Trial 5: Closed the entire Excel program and reopened
Trial 6: Confirmed that sheet/workbook protection options are not
activated
None of them worked successfully.
How can I have correct result displayed for the formula?
Would appreciate your help.
Thanks,
Guy

guy.yeon

guy.yeon

I am trying to create a new column in my pivot table that calculates the
relationship (a ratio) between two previous columns. Those two columns are
calculations from the base data.
When I try to insert a calculated field or item in the pivot table, my only
options are to create a calculation using the column names in the data
worksheet.
help?
Beth

=?Utf-8?B?QmV0aHNoZXA=?=

=?Utf-8?B?QmV0aHNoZXA=?=

Hi... i'm new to this forum and have looked for an answer to my question w/
no luck. I have several work sheets in my workbook that feed into a summary
work sheet. I try setting my workbook calculation to 'Automatic' under
'Excel Options' -> 'Formulas', but Excel will not 'Save' this change. Each
time i go back to check it is set to 'Manual'. The only way my formulas
update on each individual work sheet and on my summary worksheet is to hit
F9. Why doesn't it do it automatically?
Thanks for your help.
--
qualitywoodworking

=?Utf-8?B?cXVhbGl0eXdvb2R3b3JraW5n?=

=?Utf-8?B?cXVhbGl0eXdvb2R3b3JraW5n?=

Is it possible to use the results from a drop-down box selection in a
calculation for another field? I am creating a template in Word. On it I
wish to make a selection from two drop-down boxes. Once the second is
selected I wish to have posted in a field elsewhere on the template the
product of the two selections. Is this possible? I cannot seem to get the
field calculation formula to understand that the bookmarked fields (from the
drop-down boxes) are usable for calculation.

=?Utf-8?B?U2FyYUthdGhlcmluZQ==?=

=?Utf-8?B?U2FyYUthdGhlcmluZQ==?=

Aloha,
I've grown used to the previous versions of word having a
calculations (5.1 and 98) function that all you had to do was drag
the cursor over the items to be computed while holding the option key
you get a total. Can I still do this with the later versions of
word/office X for macintosh? If not, why not, it was great and I used
it all of the time.
Aloha,
Ralph

write-maui

write-maui

How can I create a macro "button" over a series of columns that will cause a
formula in another part of the sheet to ignore the value that the column
calculates to?
i.e.
X X X
20 60 9
40 50 21
_______________
60 110 30 =200
I would like to click on the button (represented by the X) or perhaps more
than one button, have the button change appearance and then that column
total wouldn't be used to calculate the answer (200)
Does that make since?

churchmouse

churchmouse

I have plotted out a worksheet, but the problem is that it is trying to
calculate empty cells as having a value of zero. This means that whenever it
is a divide function, it shows up as an error. I need it to count empty
cells as having no value, or to just ignore them, so that it does not affect
related formulas. Any help?

=?Utf-8?B?RXhjZWwgTm9vYg==?=

=?Utf-8?B?RXhjZWwgTm9vYg==?=