How do I calculate cells without losing the milliseconds?

S

Smylis

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

David Biddulph

Smylis said:
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??
Click to expand...

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

Graham Y

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
 
Top