Microsecond time precision required

From: kenr (kenr.1kkczt_at_excelforum-nospam.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 14:00:18 -0600

Hi Guys

I am using Excel to parse a data file containing the time in
microseconds. I have tried a number of ways but cannot get around
Excel's millisecond precision limit.
For example if the inputted file contains 15:34:59.178533, I would like
to be left with just 0.178533. However excel always rounds the value
up to 15:34:59.179. :confused:

I've tried custom formats etc and am very frustrated at what I thought
would be a simple task.

I've used the HOUR(),MINUTE(), and SECOND() functions to be left with
the sub-second part but can only get 0.179.

I'm sure someone must have faced this problem before and I have
searched the archives but can't find anything. I would REALLY
appreciate some help on this please .

=8-) 

-- 
kenr
------------------------------------------------------------------------
kenr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20021
View this thread: http://www.excelforum.com/showthread.php?threadid=346084

Relevant Pages

  • Re: Programmatically create html as input to Excel
    ... The data file used to be output sent directly to a printer. ... I'm enhancing this program to have Excel be a third target. ... Your best bet is to turn on the macro recorder and do some formatting, ... indicate that if a cell in column 10, 11, or 13 is numeric, it should be ...
    (microsoft.public.excel.programming)
  • Re: Microsecond time precision required
    ... > microseconds. ... However excel always rounds the value ... maybe the problem is limited digits number, ... is your input data file simple text file, ...
    (microsoft.public.excel)
  • Re: Mail merge source document hangs on opening
    ... Cindy - thanks for your response. ... change the location of the data file. ... the formating is correct in the excel file. ... >> Waiting for Microsoft Excel to accept DDE Commands ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Connecting a Pivot Table to .Tab Data file ** Minimise the connexion setup hassle
    ... Am I right in thinking that setting up the connexion this way avoids the ... is Excel not creating an .odc behind my ... I have a Pivot Table that aggregates data from a .tab data file using the ... a reference to an odc file. ...
    (microsoft.public.excel.misc)
  • Re: Excel - Corrupt File / Urgent
    ... > I have an Excel 2000 data file that is corrupt and I can't open it with ... > usual steps (e.g. excel viewer, web file save, linking, etc.) Now, when I ... > I find it incredible that MICROSOFT does not have a similar FREE utility ... I have not seen anything offered from Microsoft, ...
    (microsoft.public.excel.misc)