Moe
Reputation: 51
Convert Days, Hours, Minutes to Seconds (Dd HH:MM:SS) in Excel
How can i convert cell in excel to seconds
Example:
2d 07:51:00
Expected Output:
201060
Upvotes: 0
Views: 395
Answers (1)
Scott Craner
Reputation: 152450
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
Upvotes: 3
Related Questions
- How to convert dd:hh:mm:ss format time into seconds in Excel spreadsheet
- How to convert minutes into (YY MM DD HH:mm:ss) in excel?
- Excel functions to covert X days, x hours, X minutes in actual minutes
- Converting Date-Time (yyyy-mm-dd hh:mm:ss) format to seconds in EXCEL
- How can I convert dd hh:mm format into hours?
- Convert minutes and seconds to hours, minutes and seconds in Excel
- Convert hh:mm:ss to decimal days
- Excel: convert seconds to dd Days hh:mm:ss format
- Excel time dd/hh/mm conversion to minutes only
- Convert time format mm.ss.dd to seconds in MS Excel