Any hope of doing math on: 2009/02/04-10:49:12.229510 ?

[Rich]

Is the serial format for time inin MS based on decimal or is it something
else? Which I couldn't use I suppose.

Would think I could convert to serial format, do the math, then convert
answer back, but can't seem to get any of the functions to return just a
decimal number.

is this the right approach or do I need to break the time down and do my own
math?

Regards,

Rich

 

[BruceM]

Are you trying to subtract 10 hours, 49 minutes, 12.229510 seconds from
February 4, 2009? If so, from what time of day on February 4? In what
format would you wish to see the result?

Access dates are serial numbers in which the integer portion is the number
of days that have elapsed since Dec. 31, 1899 (I think) and the decimal
portion represents the elapsed time (fraction of a day) since midnight.
However, there is no provision in Access for displaying time intervals
smaller than a whole second (unless that has changed in Access 2007).

In any time calculation I think you will need to use the format dd/mm/yyyy.