How can i convert cell in excel to seconds

Example:

2d 07:51:00

Expected Output:

201060

>Solution :

If one has TEXTSPLIT:

=SUM(--SUBSTITUTE(TEXTSPLIT(A1," "),"d",""))*86400

Else:

=(SUBSTITUTE(LEFT(A1,FIND(" ",A1)-1),"d","")+MID(A1,FIND(" ",A1)+1,LEN(A1)))*86400