General

Excel and calculations
By default Excel is set to automatically recalculate formulas. However, users are finding that the setting is changing to calculate manually (even though they do not know that the option exists/haven't gone into Tools/Options to change it). Is there a shortcut key/way this can be triggered accidentally?? Thank... 16 Jan 2006 05:42

How can I edit a hyperlink in more than one cell at once
I have a workbook with appoximately 130 worksheets in it. On each sheet one cell is linked to the "master" sheet which lists all of the others. This sheet is named "Words". I now need another sheet named "Words" and the "Words" sheet changed to "Main". Easy at first but all the other sheets are linked to the "W... 9 Jan 2006 12:46

Percentage calculation
In G18, I want this cell to calculate 10% of the number in H17. How can I make a formula for this? I try to simply put in =H17(0.1), but it gives me a !REF error. Thanks. -- Roz ------------------------------------------------------------------------ Roz's Profile: http://www.excelforum.com/member.php?action=ge... 6 Jan 2006 14:35

Converting hundredths
I have a timesheet that calculates hours worked. I'd like to enable the data entry person to enter the military time in hundredths. My current formula for calculating the hours is: ((F6 (time out)-C6(time in)+(f6<c6))*24. However, our timeclock generates military time in hundreds, i.e... 14:99-21:96. Is there a ... 20 Dec 2005 18:21

Expand curly bracket symbol over multicells
I recall some months ago being able to add a curly bracket symbol and being able to span the symbol over multiple cells for purposes of adding an inclusive notation. Have lost the instrux for doing this. Can anyone help out? Many thanks -- Hal Plimpton ----------------------------------------------------------... 19 Dec 2005 22:34

Calculating Minutes in Excel
Hello, I am trying to add minutes up in Excel, but I can't figure out which formula to use to display the total correctly? I am trying to add 55 plus 55 as integers(110), I need the total to be displayed as 1.50 (.50) being the difference in minutes. Here is a better look. A1 = 55, A2 = 55, A3 =SUM(A1:... 20 Dec 2005 12:36

sort function to sort for bell curve
Need to sort a data list to create a bell curve when graphed. ... 16 Dec 2005 14:11

IF statements
Hello, Need some help in using the IF statement. I have two columns A & B A has 4 types of words: RoHS RoHS5 RoHS6 No Column B has: Yes No I need the following output in three separate columns: X, Y, Z I want to check if A1 = RoHS and B1 =yes....X1= compliant If A1=RoHS and B1=no...X1=complian... 2 Dec 2005 17:42

Calculating Time
Time is a wonderful thing......only I have spent ages trying to sort this problem out with no success, so would be really grateful for some help from the experts please ... I have a sheet which is designed as a "work timesheet", Column D is a start time Eg 09:00 Column E is the finish time EG 16:45 Column G... 1 Dec 2005 15:11

Percentage Formula
I have a table of passes and fails from my students as i am a driving instructor and i would like to have a running column showing the percentage of passes/fails ie name test date result joe bloggs 11/05/2005 fail joy biggs ... 28 Nov 2005 14:33