Change time duration to [HH]:MM:SS format

[JoostDofferhoff]

Hi,

I have a list with different formats of time durations which i would all like to change to the [HH]:MM:SS format. The time duration formats i now have are like this

08;23
03'21"
60'

Is there a way to automatically change all of these to have the format 00:00:00, so they would become
00:08:23
00:03:21
01:00:00
?

Thanks so much in advance

[karolus]

Hallo
Select the Cells in Question, and do →→search and replace:

search:
^(\d+)[;'"](\d+)?[;'"]?
replace:
00:$1:$2
x Selection only
x regular Expression
→→replace all
adjust the Cellformat to [HH]:MM:SS