I have a column in which I need to find the average duration however as you can see below the data needs cleaning. I would like to convert each cell to seconds if possible. which is the simplest way to tackle this?

The data is very messy with lots of mixed date formats both text and numerical.

Thank you

Duration

4 minutes

3 minutes

3 minutes

5 minutes

Driving

Seconds

10 seconds

<1 minute

3 minutes

3 minutes

3 minutes

5 min

5 minutes

3 minutes

3 minutes

3 minutes

30 seconds

30 seconds

1 minute

2 minutes

2 minutes

1 minute

2 minutes

20 minutes

15 seconds

80 sec

3 minutes

10 mins

2 min

2 minutes

30 seconds

5-8 min

4 hrs

4 hrs

10 seconds

5 seconds

3 min

50min

3-4 minutes

3-4 minutes

Approximately 5 minutes

1hour

1 min

1 minute

1 minute

10 Minutes

10 Minutes

10 Minutes

1 minute

30 mins

30 mins

30 mins

3-4 minutes

4

10 seconds

15 seconds

1 minute

Unknown

10 minutes

10 seconds

6h 30 mins

10 seconds

10 seconds

1 minute

Seconds

20 seconds

12 minutes

5 seconds

20 seconds

8-10 seconds

1 minute

~2 seconds

1 minute

~2 minutes

10 minutes

1 minute

10 seconds

5 hours

2 hours

Ongoing

28 seconds

20 minutes

2 seconds

6-8 minutes

60 seconds

30 seconds

10 minutes

20 minutes

1 minute

~4 seconds

2 minutes

20 mins

1 minute

10 minutes

1.5 hours

30 minutes

3 seconds

1 hour

20 minutes

5 minutes

1-2 minutes

3-5 seconds

30 seconds

4 seconds

5 seconds

unknown

2 minutes

0.208333333

10 minutes

3.5 minutes

20 minutes

2 minutes

3

5 minutes

45 minutes

2 minutes

5 minutes

Hour

30 seconds

2 seconds

3 minutes

5 minutes

4 minutes

2 minutes

3 minutes

10 minutes

Don't know

1 minute

Half an hour

6 minutes

5 minutes

5 minutes

5-10 minutes

1 minute?

3 minutes

a few hours

20 minutes

20 seconds

2 seconds

3 seconds

1 hour 20 minutes

2 minutes

5 minutes

10 minutes

2 minutes

5 minutes

1 minute

2 hours

5 minutes

5 hours

30 minutes

4 minutes

5 Minutes

20 minutes

5 minutes

5-10 minutes

5 minutes

0.104166667

20 seconds

15 seconds

4 seconds

3 minutes

30 seconds

5-6 minute

~45 minutes

10 minutes

1 second

10 minutes

5 minutes

40 seconds

2 minutes

2 seconds

20 minutes

1-2 minutes

3 minutes

10 seconds

1 minute

8 minutes

20

10 minutes

10 minutes

5 minutes

5 minutes

15 minutes

25 seconds

2 minutes

5 minutes

20 minutes

5 minutes

:15

Approx. 1 minute

50 MINUTES

20 minutes

Seconds

8 min

Few seconds each

7 minutes

5 minutes

5 minutes

0.010416667

5 Minutes

2 minutes

3:00 Minutes

2 minutes

5 to 10 minutes

5 min maybe

5 minutes

5 minutes

1 minute

20 seconds

10

Less than a minute

0.125

5 minutes

12 minutes

5 minutes

Varied

5 minutes

5 min

5 Minutes

0.208333333

3 minutes

3 minutes

30 minutes

10 minutes

30 minutes

5 Minutes

30 seconds

10 minutes

5 minutes

4 minutes

45 seconds

3 seconds

11 minutes

15 minutes

3 minutes

20 minutes

20 seconds

2-3 minutes

10 minutes

6 seconds

30 secconds

1 hour

12 minutes

1.5 minutes

>2 minutes

30 seconds

5 seconds

~8 seconds

2 seconds

10 seconds

10 seconds

5 seconds

5 seconds

9:00-2:00

30 seconds

20

1 minute

3 seconds

5 seconds

10 minutes

25 seconds

7

25 minutes

20 minutes

30

1 hour

>30 minutes

2 hours

10 minutes

1 hour

15 minutes

5 seconds

15 seconds

3-4 seconds

5 seconds

15 seconds

4 minutes

60 seconds

Hours

20 minutes

Still occuring

3 hours

4 seconds

0.840277778

15 minutes

Ongoing

10 seconds

10 seconds

1 minute

15-20 minutes

5 minutes

1 hour

15 minutes

3 hours

10 minutes

4-5 seconds

5 minutes

4 minutes

3 hours

Seconds

10 minutes

10 minutes

3 seconds

~90 seconds

2 seconds MAX

2 minutes

1 hour +

5 minutes

5 minutes

5 minutes

15 seconds

3-4 minutes

2 minutes

40 minutes

30 seconds

ongoing

15 minutes

0.06875

5 minutes

1 second

10 minutes

10 seconds

15 minutes

4 minutes

1 minute

1 minute

3 minutes

1 minute

5 minutes

10 minutes

15 minutes

3 minutes

5 minutes

15-20 minutes

1 minute

Few minutes

20 minutes

15 minutes

30-60 seconds

5 minutes

15

10 minutes

10 seconds

5 minutes

5 minutes

1 minute

7 minutes

45 seconds

3 seconds

10-15 minutes

3

15 seconds

4 minutes

60 minutes +

1.25

5 minutes

0.125