Thread: How do I calculate cells without losing the milliseconds?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default 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


Reply With QuoteReply With Quote