AnsweredAssumed Answered

Problem with transformation hour formats

Question asked by Teresa Tavernelli on Oct 15, 2018
Latest reply on Oct 18, 2018 by RAKOTONDRASOA Andry

Hello Everyone,

 

I have a little problem with a transformation. I have a duration and the format is like this: 2h3m30s888ms and I need to transform all that to seconds the result should be 7410 (in seconds).

 

I have splitted and calculated the duration on seconds and that and works perfectly. But when I don't have hours and the format is like this 2m30s888ms or 30s888ms doesn't works, So anyone has an idea that what can I do?

 

Thanks,

 

Teresa.

Outcomes