Formula to subtract two time stamps

**jiminic** · 02-13-2013, 08:57 PM

Hello,

I need to subtract one timestamp value from another, but I am getting a #VALUE! error whenever I try it.

The values I am trying to subtract all have the same format as below:

00:50:26.170

00:50:26.291

I need to be able to subtract the lower number from the higher number and display the results as a number value.

Is there a way to achieve this?

**Pete_UK** · 02-13-2013, 09:03 PM

Try this:

=MAX(A1:B1)-MIN(A1,B1)

This will give a result in time format - if by "number value" you mean you want the fractions of a second, then do this:

=(MAX(A1:B1)-MIN(A1,B1))*24*60*60

If you want the result in milliseconds, then multiply by 1000.

Hope this helps.

Pete