I need a formula to transform P7DT22H40M46.6285276S into hours and minutes

How To
1

Hi, I’m building a scenario to pass monthly time tracked in Jibble to Monday, but I’m having trouble transforming days to hours. I use text parser P(?:T)?(?:(?\d+)D)?T?(?:(?\d+)H)?(?:(?\d+)M)?, then this formula {{round(((ifempty(4.days; 0) * 24) + ifempty(4.hours; 0) + (ifempty(4.minutes; 0) / 60)); 2)}} , and then I get 3 sets of hours standing in a row 168221, but it should be added like 168+22+1.

2

Hey Jane,

you need to use parseNumber() first. Then + will sum them up. Otherwise its just a text string and + will combine them in one word.

2 Likes
3

Thanks a lot, it worked!