I want to use only a start and end time.
*24 works great for the day shift, but the night shift is wrong.
Does anyone know how to correct this ?

I am an industrial chemist and I have a sophisticated spreadsheet for
modelling chemical processes. I use Userforms and have a rudimentary
knowledge of VBA. I use alot of macros and have found the advice on this
website absolutely wonderful

I have a worksheet with hyperlinked cells in them.  All the text are
in Arial
size 8.  However, whenever I insert a hyperlink, the text
automatically

I use Excel 2003, SP3 (part of MS Office Pro 2003) on WinXP OS
Is it possible, from the original program CD, to reload or repair Excel ONLY.
Using Detect & Repair effects all the other Office applications and I would
like to limit the operation just to Excel

In Case You Missed My First Post !!!
I'm producing a template for a football pool I am in.  It's called a "Margin
Of Victory" pool.  Just like most, the person with the most points at the end
of the NFL season wins.  It works just like the name.  Each person chooses on

I have list with dates eg 11/24/2007 9:45 pm I need to transform those dates
to 2007-11-24 9:45pm. I have tried the cell format and the data,text to colum
ymd and still have not been able to fix it. I so some one had add extra
column and ad a function. I just don't know how to ...

I upgraded to Office 2007 when I heard that the new upper lmit in Excel was
1MM rows.  I am running Offide 2007 Enterprise on XP Pro SP2 on a machine
with 4GB Ram and dual Intel zeon 3.06Ghz processors.
I generated the workbook from Crystal Reports XI.  I converted it to the

I need to combine the wordings in two columns into one under the third column
e.g.
     col A       col B        col C      
1    AM/       S3           AM/S3

I need to shadow the outside of  a cell and can't seem to find the botton. I
have 2007 excel.

I have a macro with many divisions, for many
of the divisions both the numerator and denominator are zero.
It's the no data case, so it's 0/0 for that condition
(or else it's a fraction).

I have devised a some custom functions as required for my daily office work!
I think I should form a single addin file for the same.
Does an such addin needs to have such functions' codes be typed:
1. In the worksheet code; or

I have lost my track while working when power supply interrupted in a work
book which is having many sheets. Thanks to recovered file by which I can
continue the work. But I forgot that in which cell of the sheet I was typing.
How to go to the same cell or last cell to continue ...

Of course I know how to filter columns in Excel, but is there also a way to
filter rows? I have not found this function in Office 2007.
Is this possible at all?

Can any friend explain to me what does the following statement means:
Application.Caller.Parent.Evaluate
Thanx!

Is there an add-on for Excel (like print to pdf) that will allow you to print
from a website into an Excel Spreadsheet?  I have tried the copy/paste route
- it takes too long and requires reformating to get the data to show up
correctly.