How do I calculate cells without losing the milliseconds?
 

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??

How do I calculate cells without losing the milliseconds?
 

"Smylis" wrote in message
...
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
--
David Biddulph

How do I calculate cells without losing the milliseconds?
 

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

"Smylis" wrote:

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??