How to format time period in Make.com

Hello.

Currently I’m trying to convert time format from Clockify into an Asana Project page. To do that I need to somehow convert time period given by Clockify (which is f.e. in format PT10H12M7S but could be also f.e. PT37M33S). I do not know how to set a variable (or use any other module?) to convert such a given time format into one easily visible time format which is also able to be calculated inside Asana columns.

So, f.e., when I have a time format (f.e. PT10H12M7S) that i got from a task duration I’d like it to convert to one number. I’ve been thinking about something like 10(representing hours)*60+12(representing minutes) divided by 60. There’s no need to include seconds.

This would fill a column with 10,2 which would represent 10 hours and 2/10th of an hour (which is 12 minutes).

But I currently do not know how to convert time format from Clockify into a time format that I’ve explained above. Could someone please help?


I’m not an expert and still learn but I would use regular express to extract the numbers and reformat it.