Excel help...

Eli

Super Moderator | Elite Member
Oct 9, 1999
50,419
8
81
Hi Guys,

So I've got some data logging action going on with my car.

I get 4-6 datapoints per second. How do I convert the timestamps to elapsed time?

Column A Column B

8:13:14 PM 0:00:01
8:13:15 PM 0:00:00
8:13:15 PM 0:00:00
8:13:15 PM 0:00:00
8:13:15 PM 0:00:00
8:13:15 PM 0:00:01
8:13:16 PM 0:00:00

So after each second change, I would want it to increment. It should show 2 seconds as the elapsed time with the above sample. But I can only get it to show the one second difference.

:confused:
 
Last edited: