Working out time from start

[crystaloscillator]

I have been recording DJ mixes using Traktor software
It gives the time played in the following format;

2026/4/4 19:59:48
2026/4/4 20:01:29
2026/4/4 20:04:42

This would be for the first three tracks in the mix respectively
There might be as much as 20 plus songs in the mix like this

I want the first track to be
00:00:00

The second track to be the the time of the second minus the time in the first
The third track to be the time of the third track minus the first etc

So I know what time to click on WMP for that song in the mix

How do I do this?
Thanks

[EarnestAl]

First get rid of the dates, the forward slash in the date is a problem anyway. Select the column and click Data > Text to Columns, in the dialogue select Space as separator and check that it splits cleanly into two columns. OK.

I deviate from your request to subtract because I don’t understand why.

1. In column C next to 19:59:48 enter 00:00:00 (your start time)
2. Below it in Column C enter =C2+B2 this gives the start time of the second track
3. Drag the corner down to fill the remaining cells in column C with the relevant start times

You can delete Column A now, the date is irrelevant.
StartTimesOfTracks.ods (10.8 KB)

[Villeroy]

@crystaloscillator

It gives the time played in the following format;

and exports text files (csv), right?
The resulting date-time values are meant to be clock times, right?
With the following options, you get the date-time values imported correctly:

Then subtract the second value from the first and drag down.

[karolus]

enter =A2-A1 into B2 and pull down.