Data conversion

Hi,

I am new to this, I have a data set with a field time format of "hh:mm:ss" and I would like to convert it seconds ONLY.

For example: 00:01:20 should return to 80

Thanks,
Alex

What you have to do is split values using : as delimiter
than multiply hours by 3600, minutes by 60 and add all of them together

Thank you for quick reply, I have never thought that it is so simple.