Proper Time (Duration)

1

I have a table with weird time, this is an example :
PT11M12S
so what so this indicate 11min , 12 sec , so what i want first to have the total seconds like (11x60)+12 but there are multiple problems im facing … like sometimes it has min sometimes not , sometimes has second sometimes not… sometimes also has hours sometimes not … how can i get the total second, then proper formating like : 1h 12min 20sec

is that possible?? see the doc if you want to help me figure that out. thanks in advanced

2

Hi @SALEM_MALIBARY,

RegExExtract is probably going to be your best bet. I have added three columns to your doc to extract hours, minutes and seconds separately, then added a formula to the Time in Sec column.

Hopefully that is what you are after.

(You could of course condense it all down into a single formula, I just did it this way to make it easier and clearer)

1 Like
3

O.O Lol i just missed this easy solution. Thanks this what i needed . i can do what i needed by this