Spreadsheet: 826248d1681895056-how-to-calculate-the-time-difference-in-seconds-between-cells-with-hh-mm-ss-sss-example_timesteps
Sheet: Sheet1

time |  | time difference |  | ax (m/s^2) | ay (m/s^2) | [NAME] (m/s^2) | aT (m/s^2)
15:11:38:604 |  | 0 |  | 0.1205 | -0.0089 | -0.0335 | 0.125
15:11:38:605 |  |  |  | 0.0816 | 0.0026 | 0.0143 | 0.083
15:11:38:610 |  |  |  | -0.0418 | 0.0143 | -0.0142 | 0.046
15:11:38:619 |  |  |  | -0.0856 | -0.0021 | -0.1186 | 0.146
15:11:38:620 |  |  |  | -0.0654 | 0.0008 | -0.0226 | 0.069
15:11:38:626 |  |  |  | 0.0057 | -0.0302 | 0.1342 | 0.138
15:11:38:629 |  |  |  | 0.0531 | -0.0481 | 0.1711 | 0.185
15:11:38:634 |  |  |  | 0.0345 | -0.048 | 0.1317 | 0.144
15:11:38:644 |  |  |  | -0.0173 | -0.0254 | 0.0832 | 0.089
15:11:38:646 |  |  |  | -0.0463 | 0.0012 | -0.0029 | 0.046
15:11:38:654 |  |  |  | -0.0342 | -0.0009 | -0.0361 | 0.05
15:11:38:655 |  |  |  | 0.0101 | -0.0028 | -0.0121 | 0.016
15:11:38:660 |  |  |  | 0.0405 | 0.0001 | 0.0118 | 0.042
15:11:38:665 |  |  |  | 0.0579 | 0.0033 | -0.0215 | 0.062
15:11:38:669 |  |  |  | 0.0529 | 0.0119 | -0.045 | 0.07
15:11:38:676 |  |  |  | 0.0011 | 0.0116 | -0.0636 | 0.065
15:11:38:681 |  |  |  | -0.0122 | 0.0121 | -0.0916 | 0.093
15:11:38:684 |  |  |  | -0.002 | 0.0086 | -0.0623 | 0.063
15:11:38:691 |  |  |  | 0.0082 | 0.0055 | 0.0047 | 0.011
15:11:38:695 |  |  |  | -0.0001 | -0.0214 | 0.0331 | 0.039
15:11:38:703 |  |  |  | 0.0064 | -0.0103 | 0.0519 | 0.053
15:11:38:705 |  |  |  | -0.0111 | -0.0141 | 0.042 | 0.046
15:11:38:709 |  |  |  | -0.0339 | -0.0183 | 0.0322 | 0.05
15:11:38:717 |  |  |  | -0.0291 | -0.0135 | 0.0319 | 0.045
15:11:38:719 |  |  |  | -0.0107 | -0.0187 | 0.0506 | 0.055
15:11:38:725 |  |  |  | 0.0119 | -0.0195 | 0.0407 | 0.047
15:11:38:730 |  |  |  | 0.0012 | -0.0253 | 0.0309 | 0.04
15:11:38:735 |  |  |  | 0.0241 | -0.0027 | 0.0117 | 0.027
15:11:38:740 |  |  |  | 0.0089 | 0.0008 | -0.0168 | 0.019
15:11:38:745 |  |  |  | 0.0129 | 0.0047 | -0.0404 | 0.043
15:11:38:752 |  |  |  | 0.0075 | 0.0042 | -0.0448 | 0.046
15:11:38:755 |  |  |  | 0.0261 | 0.0089 | -0.0302 | 0.041
15:11:38:760 |  |  |  | 0.0167 | 0.0044 | -0.0157 | 0.023
[NAME] |  |  |  | 0.0174 | -0.0044 | -0.0013 | 0.018
15:11:38:769 |  |  |  | -0.0006 | -0.013 | -0.006 | 0.014
15:11:38:774 |  |  |  | -0.0091 | -0.0025 | 0.0036 | 0.01
15:11:38:780 |  |  |  | -0.0083 | -0.0065 | 0.0178 | 0.021
15:11:38:785 |  |  |  | -0.0031 | -0.0058 | 0.0272 | 0.028
15:11:38:790 |  |  |  | -0.0028 | -0.0007 | 0.0317 | 0.032
15:11:38:796 |  |  |  | -0.0027 | -0.015 | 0.0457 | 0.048
15:11:38:800 |  |  |  | 0.0019 | -0.0153 | 0.0454 | 0.048
15:11:38:805 |  |  |  | -0.0129 | -0.0063 | 0.0165 | 0.022
15:11:38:810 |  |  |  | 0.0103 | -0.0117 | 0.0069 | 0.017
15:11:38:815 |  |  |  | 0.0046 | -0.0029 | -0.0026 | 0.006
15:11:38:820 |  |  |  | 0.0277 | 0.006 | -0.0026 | 0.028
15:11:38:826 |  |  |  | 0.0128 | 0.0007 | -0.0073 | 0.015
15:11:38:830 |  |  |  | 0.0127 | -0.0044 | -0.0072 | 0.015
15:11:38:835 |  |  |  | 0.0126 | 0.0004 | -0.0071 | 0.015
15:11:38:843 |  |  |  | 0.0128 | 0.0054 | -0.0166 | 0.022
15:11:38:845 |  |  |  | 0.0084 | -0.0037 | -0.0116 | 0.015
15:11:38:850 |  |  |  | 0.0041 | -0.003 | 0.0027 | 0.006
15:11:38:858 |  |  |  | -0.0002 | -0.0072 | 0.0217 | 0.023
15:11:38:860 |  |  |  | -0.0044 | -0.0068 | 0.0168 | 0.019
15:11:38:865 |  |  |  | -0.0087 | -0.0016 | 0.0167 | 0.019
15:11:38:870 |  |  |  | -0.0133 | -0.0157 | 0.0213 | 0.03
15:11:38:875 |  |  |  | 0.0058 | -0.011 | 0.0259 | 0.029
15:11:38:882 |  |  |  | -0.0087 | -0.0111 | 0.0209 | 0.025
15:11:38:885 |  |  |  | 0.0148 | -0.0114 | 0.0113 | 0.022
15:11:38:890 |  |  |  | -0.0046 | 0.0025 | 0.0065 | 0.008
15:11:38:896 |  |  |  | -0.0048 | 0.002 | 0.0017 | 0.005
15:11:38:901 |  |  |  | 0.0044 | 0.0016 | -0.0078 | 0.009
15:11:38:905 |  |  |  | 0.0041 | 0.0013 | -0.0125 | 0.013
15:11:38:910 |  |  |  | 0.0041 | -0.0036 | -0.0076 | 0.009
15:11:38:917 |  |  |  | 0.0136 | 0.0011 | 0.002 | 0.014
15:11:38:920 |  |  |  | 0.0185 | 0.0012 | 0.002 | 0.019
15:11:38:925 |  |  |  | 0.0044 | 0.0014 | 0.002 | 0.005
15:11:38:930 |  |  |  | 0.0094 | -0.0126 | 0.0068 | 0.017
15:11:38:936 |  |  |  | 0.0002 | -0.017 | 0.0067 | 0.018
15:11:38:942 |  |  |  | 0.0051 | -0.0023 | 0.0019 | 0.006
15:11:38:945 |  |  |  | 0.0005 | -0.007 | 0.0067 | 0.01
15:11:38:951 |  |  |  | 0.0054 | -0.0022 | 0.0351 | 0.036
15:11:38:956 |  |  |  | -0.0089 | -0.0118 | 0.0111 | 0.019
15:11:38:965 |  |  |  | -0.0042 | -0.0024 | 0.0111 | 0.012
15:11:38:967 |  |  |  | 0.0051 | -0.0027 | -0.008 | 0.01
15:11:38:971 |  |  |  | 0 | 0.0018 | 0.0206 | 0.021
15:11:38:976 |  |  |  | 0.0046 | -0.0032 | 0.0062 | 0.008
15:11:38:982 |  |  |  | -0.0002 | -0.0081 | -0.0034 | 0.009
15:11:38:986 |  |  |  | -0.0003 | -0.0082 | 0.0062 | 0.01
15:11:38:990 |  |  |  | -0.0097 | -0.0034 | -0.0033 | 0.011
15:11:38:995 |  |  |  | 0.0046 | -0.0081 | 0.0015 | 0.009
15:11:39:000 |  |  |  | -0.0048 | -0.0127 | -0.0033 | 0.014