Microsoft Query / Excel Date.Time
 

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?

Microsoft Query / Excel Date.Time
 

Modify your formula using mod(A1,1) where A1 is the cell with the time. A
date value uses whole number to count the number of days since Jan 1, 1900.
The time portion of the number is the fraction where an hour is 1/24 and a
minute is 1/(24*60). The mod function will leave only the fractional part of
the Time/Date value.

" wrote:

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?