Forum Discussion
milliseconds diff
I have excel Office Professional 2016 file with dates on A1 and B1 format YYYY-MM-DD HH-MM-SS:SSSS and need to get the diff in milliseconds. Could not get it via DATE nor TIME functions.
If you have actual time, not text which is looks like time, variant could be
=MOD(A1,1/24/60/60)*24*60*60*1000
The time recorded for each second, I need to calculate time difference, my data is sensor data (acceleration x, y, z). I am trying to calculate total distance which needs the time difference like(c2-c1) for all rows.
Distance=(initial velocity*timediff+0.5*acceleration*timediff^2), so the initial velocity=0 but i was not able to get the actual distance, i am using python to calculate the distance
Distance=(initial velocity*timediff+0.5*acceleration*timediff^2), so the initial velocity=0 but i was not able to get the actual distance, i am using python to calculate the distance
AishaEdrah
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.