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:

201060

CodePudding user response:

If one has TEXTSPLIT:

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

enter image description here

Else:

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

enter image description here

  • Related