From timestamp to counter/time in excel

[pHoldensgaard]

Hi all,

I have a lot of timestamps, formatted like

21.05.2021 12:10:42
21.05.2021 12:10:43
21.05.2021 12:10:44
21.05.2021 12:10:45
21.05.2021 12:10:45
21.05.2021 12:11:02

and so on..

Instead of having a timestamp to each row, I want to change it to a counter/time, so it becomes

00.00
00.30
00.55
01.02

and so

Any help is appreciated :D

 

[Larry Haydn]

* Can you just format the column to time (HH:MM)?

* Or do you need the timestamp column to just store time?

* Are you saving the data using VBA (or SQL)?