Excel time difference between dates jumping with day change

71 Views Asked by At

I am trying to calculate the time elapsed in a list of dates spanning 3 days.

When the date changes from 10/1/2021 to 10/2/2021 my time difference jumps up +30 days!!!

Here is the screenshot:

enter image description here

Does anyone know how to solve this?

I would like for line 454 to read 0:7:22:02.841.

Ultimately what I am trying to do is to use the the elapsed time as my X axis.

Here is the link for the sample files:

SampleData.xlsx

CSV_SampleData.csv

Thank you very much.

[EDIT]: Changed link to Google Drive.

[EDIT2]: Had to move on to something else and never did find a solution for this. Thank you all for the comments.

0

There are 0 best solutions below