LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 losing Linked Cells Distressed Links and Linking in Excel 2 August 28th 06 09:49 PM
cells will not calculate jch2005 Excel Worksheet Functions 1 July 22nd 05 01:28 PM
calculate percentage of two cells Suzie Excel Worksheet Functions 4 December 3rd 04 05:27 PM
calculate the sum of cells where values are between 6 and 10 in e. SueC Excel Worksheet Functions 2 November 28th 04 11:47 AM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 08:03 AM


All times are GMT +1. The time now is 06:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"