Make duplicate Date/time values unique

[Siboska]

Hi, 

I need to sort a name column based on  Date/Time collumn. 
The problem is that I have some duplicates in the Date/Time column and therefore the Sort By Collumn will fail. 

To solve the issue I was wondering if you somehow can find all duplicate date/time fields and then plus 1 second to on of the fields and thatway make them unique. 

Input:

Date

07/10/2021 11.33

07/10/2021 11.33

07/10/2021 16.01

12/10/2021 07.06

13/10/2021 13.23

13/10/2021 13.23

OutPut:

Date sort column

07/10/2021 11.33

07/10/2021 11.34 (1 added second)

07/10/2021 16.01

12/10/2021 07.06

13/10/2021 13.23

13/10/2021 13.24 (1 added second)

[davehus · Accepted solution]

Hi @Siboska ,

Try the attached solution.

Did I help you today? Please accept my solution and hit the Kudos button.