CODEWITHSUNDEEP
excel-formula
FSakhi
FSakhi

Reputation: 19

How to calculate duration of hours, minute and second in a single row in excel?

How can I calculate only the string (word) duration of hours, minute, and second in a separate column?

enter image description here

Upvotes: 0

Views: 39

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

Lets say that with data in column A, in B1 we want to extract:

Duration: 0h:15m:11s

In B1 enter:

=LEFT(MID(A1,FIND("Dur",A1),999),FIND(",",MID(A1,FIND("Dur",A1),999))-1)

and copy downwards. We are looking for a substring beginning with Dur and ends just before the comma.

enter image description here

Upvotes: 1

Related Questions