dates in excel are actually numeric. the integer is the days and the decimal is the time.

If you have access to the data in any format other than Excel you will save yourself a lot of heartache.