Here is my problem. I have Microsoft Query running pulling data from a
datbase. The problem is when the times are pulled in I want it to drop
the date from the serial format (ddddd.ttttt) to be (0.tttt)

This way my formula calculates correctly. Where the data is being
entered the user checks a box and the time is entered and submitted.
If the user then corrects the time manually it erases the date in the
database. What I end of with is a mess of some entries as date/time
and some as just time and it messes with the formula.

Any ideas?