Convert Days, Hours, Minutes to Seconds (Dd HH:MM:SS) in Excel-CodePudding

Home > Back-end > Convert Days, Hours, Minutes to Seconds (Dd HH:MM:SS) in Excel

Convert Days, Hours, Minutes to Seconds (Dd HH:MM:SS) in Excel

Time：10-18

How can i convert cell in excel to seconds

Example:

2d 07:51:00

Expected Output:

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