CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
JMeter_User
JMeter_User

Reputation: 303

How to subtract this time in excel

I have two timestamps (please see below) of format hh:mm:ss.000. I need to find out the time difference between two timestamps including milliseconds. Pleas help.

column1 (20:47:39.891) column2 (20:47:39.755)

I have 10000 columns this way.

Upvotes: 0

Views: 110

Answers (1)

Big Josh
Big Josh

Reputation: 56

Not sure what you want, but, Excel time values are expressed in days. Just multiply the result by 86400 (number of seconds in a day). So, 86400 *(20:47:39.891 - 20:47:39.755) = 0.136 seconds of difference.

Upvotes: 1

Related Questions