View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Adding and Subtracting a Time with MilliSeconds

Hmmm... you give two different formats.

If they come in as milliseconds:

10:39:41.001

(.01 would be centiseconds, and :01 is something else entirely), then

A1: 10:39:41.91 (or 10:39:41.910)
A2: 10:39:54.01 (or 10:39:54.010)

use

A3: = A2 - A1

and format A3 with Format/Cells/Number/Custom hh:mm:ss.00 (hh:mm:ss.000)





In article ,
carl wrote:

My time comes in like this:

10:39:41:91
10:39:54.01

hours:minutes:seconds.milliseconds.

Is there a way to add and subtract times in this format ?

Thank you in advance.