How do I calculate cells without losing the milliseconds?

[Guest]

I am trying to subtract a date/time value with a time in milliseconds, but am
unable to get Excel to keep the milliseconds.

This is what I am trying to subtract:
2006-10-05 12:19:09.410 MINUS 00:00:00.859

Is there a way to do this??

 

[David Biddulph]

I am trying to subtract a date/time value with a time in milliseconds, but
am
unable to get Excel to keep the milliseconds.

This is what I am trying to subtract:
2006-10-05 12:19:09.410 MINUS 00:00:00.859

Is there a way to do this??

Format the answer as yyyy-mm-dd hh:mm:ss.000

 

[Guest]

Assuming date & time in A1 and time in A2 in A3 put =A1-A2 if you don't see
what you want change the formatting the time bit should be hh:mm:ss.000