Formula to go from Timespent in Structure in weeks,days,hours,... to a calculated colums with hours

[Els Vercauteren]

If you add column Timespent in a structure you get the logged work in Weeks,days,hours.  (f.e. 2w 3d 4h)

I need a column in structure with Formula to calculate all in hours starting from the Timespent column so i get not 5d 30m but 40.5h

Who can help

[David Niro]

Hello @Els Vercauteren ,

The formatting for timespent is going to use the Jira Formatting, which is why you see it as (2w 3d 4h).

Please try CALENDAR_HOURS(timespent) as your formula and let me know if it helps!

Best,
David

[Els Vercauteren]

Thanks, it works.

[Rodolfo So]

Hi @Els Vercauteren Can you take screenshot in Structure formula for this.

Thanks