Is it possible to have a calender drop down box to pick a date from in Excel

I would like to calculate the elapsed time in hours of 2 cells with the
format dd/mm/yyyy hh:mm:ss. The two cells represent the start and finish time
of a job and the elapsed time is 0>x<infinity. Does anybody know how to do
this?

I have in colmn 1 dates in sequence and in colmn to 2 I have numbers can
someone please tell me a formula for example where I can extract data
from colmn 2 for example from the 1st Oct 05 to the 15th Oct 05. Many
thanks if you could help me. Paul Maynard

I'm not sure this is even possible.
I am calculating the length of time someone has worked for the
company:
Column; Row A1,

this thing ahs been bugging me for quite some time . Hope that someone
can help me!
i tried to use sumproduct to calculate the sum of a product based on a
few criteria but the result i got is ZERO.

I copied a formula from another workbook and now whenever I open the
recieving workbook, it asks if I want to update links or whatever, i
did the edit find and can't find any {},[] or even !,, because I had
deleted the workbook and sheet reference, in the formula

        From a calculation part(formula in a cell) I'm getting a value
wuth three decimal places.(ex: 27.874) Now I wanted this result should
be displayed in two cells as value befor e the decimal point and in
second cell after the decimal point.

Dear Helper,
First of all , thanks for your attention. I have one question.
Using VB, I need to check the background color of one cell in the Excel,
e.g. A1.

I would like to use the CountIf statement but applied to a set of separated
cells, rather then a range.
like countif((a1;a3;a5;a7);1).
However I get a 'value' error on this.

I have a file with two spread sheets used for First Article Inspection/ First
Article Reports. I am trying to automatically load data from the inspection
sheet to the report if the results of the inspection were out of tolerance.
In other words, if a particlular cell is anything ...

How can I copy a ready formula in Excel into codelanguage for macros?
For shorter formulas (1 line (function) in Excel), it is possible to start
the recorder, activate the formula, and stop the recorder. Then the whole
formula is ready in code for macro. When I try to do this for ...

i want to list all the worksheets in a particular workbook on a worksheet
that i have named Master. Can someone hlep me on this please ?

I am exporting database files from a database program into a comma
delimited format that can be opened in excel. When I open it in excel,
all looks fine except for the date column.
The .fil file seems to have locked the date column into the straight

This is hard to explain...but I have a drop down list in a worksheet.  
Whatever name is chosen in the drop down list I need to show up in a
different sheet in a different work book.  Can this be done?  Thanks!

Dear reader,
I know i am mistaking but the problem is that i cant find my mistake.
I am actually practising IF formula... below is the situation
DATA