I get a report forwarded by an outside vendor that comes in Excel format. In
the date cell the date format is like 01-Sep-08. The time is in a separate
cell and is in military format like 18:53:14. Another field has the date and
time combined in one cell and is in the same format as described above.

I need to subtract the dates and times in the two cells from the dates and
times in the one cell. Firstly, I can't seem to convert the dates into
something that isn't text and, secondly, I can't seem to combine the cells so
they represent something numeric that can be used in a formula.

Is it possible to do what I want or should I look at Access or some other
solution to help me do this? (Well, it's not really what I want but what my
boss wants:))