Excel formula to calculate delta in msec between 2 timestamps

[RFSpecialist]

Hi All.

Do you know a function in Excel that can calculate delta in msec between 2 timestamps?

With YYYYMMDD HHMMSS like this one10:52:42.857?

Admin note: this post was updated with image below.

[onkar.ghatpande]

Just use this formula:

[RFSpecialist]

And how do i get to D column?

[onkar.ghatpande]

Difference of 2 time stamps like c1297-c1296.

[RFSpecialist]

Because if I make A4-A3 I get error like #VALUE.

[onkar.ghatpande]

Try changing format to number Or general.

I’m getting like this:

[ravitheleo]

@onkar.ghatpande

TEXT(B2-A2, “h:mm:ss”)

[RFSpecialist]

Thanks!