I just got a new computer and was setting up defaults in Excel, and I
mistakenly entered 'My Documents' in the Tools/Options/General field
for "At startup, open all files in." So when I start Excel it tries to
open EVERY file in My Domuments and I have to use Task Manager to kill

I am trying to calculate in and out time for a time sheet spreadsheet.  
Example: 9:00 am (in time), 5:00 pm (out time).  I devised a formula:
=IF(D7<C7,((C7-D7)*24)+((C7+D7)*24)*2,(D7-C7)*24)
It works for all senarios except if you begin with PM and end with AM.  

I would like to have the incremental change be .01 - is this possible
--
ldebond
-----------------------------------------------------------------------

Another question that I posted under Access, I hope this is the right
place to ask this.  I have a little bit of a problem, and I wasn't able
to find the solution anywhere.
I have column A "Title" that is linked with column B "Day of the week".

how can i have a pop-up window as soon as i open a certain
spreadsheet...

Im a complete n00b to excel and I really need some help.... I need
formula to tell me how much certain amounts of sheet aluminum weigh.
know a square foot of 1/8" aluminum weighs 1.8lbs. Basically I want t
type in the amount of square feet and get the weight. This may help to

I am working on a macro to compare two lists of job numbers in two
separate workbooks. If there are any matches, those duplicate jobs are
flagged. I used vlookup to accomplish this. My problem is that my
table_array could have as many as 10000 cells. When I use vlookup to

I have an excel spreadsheet with formulas linked to data in anothe
spreadsheet.  The spreadsheet with the source data is not opened.  Whe
I press the Update Link button, the cells with the formulas linked t
the closed spreadsheet returns a #VALUE# indicator.  I have to open th

I'm a support person for a large department of a university.  I'm
currently having one of the users I support experience a very odd
problem consistently that I am unable to find any kind of report on or
fix for, and am unable to fix myself.

I have Office 2003 and a MS Mouse using Intellipoint software.  I've
turned off the scroll wheel in the control panel, but it continues to
work in Excel . . . how do I turn it off everywhere?
Thanks, Bill

Hopefully there is an easy way to do this.....
I want the text on my macro button to change if the *-Sheet-* name
changes. Is this possible?
At the moment this is my vba code

I have an unusual problem in that one user creates an excel documen
with a long file name (no longer than 50 chars that i've seen) but whe
another user tries to open the spreadsheets they get the message tha
the file name is to long. Both users are on the same version an

What is the formula to make a cell always post the 1st day of the month.
For instance.. Its July and cell a1 has 07/01/2006. when it becomes August I
want that cell to auto change to 08/01/2006.

give me the perfect way to present ....my presentation for airtel company

Just need help with a quick formula.
Column A contains the Month (i.e. January, February, March etc..)
Column B contains either "Open" or "Closed"
I currently have the following formula in column C :-