May 20 2020 07:42 AM
May 21 2020 08:15 AM
If millisecond are separated by colon, entire datetime is represented as text, As variant you may parse such texts on two parts separating milliseconds, convert both parts to numbers and sum them. Concrete formulas depends on source format, e.g. milliseconds are always have fixed length or not.
One more variant is split datetime on parts with Text to Columns and after combine columns back by formulas.
But perhaps it'll be easier to correct source data.
Nov 23 2022 08:12 AM
Nov 26 2022 01:54 PM
Nov 27 2022 07:26 AM
I'm not sure about the formula and in which form and with which precision sensor returns the time.
Back to Excel, in it 1 millisecond is equal to 1/24/60/60/1000 (~1.157e-08).
As an example, you may add two time values in A1 and A2, formula below correctly returns difference in milliseconds.