How can i convert cell in excel to seconds
Example:
2d 07:51:00
Expected Output:
201060
CodePudding user response:
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