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

Question

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

Rodolfo So_z2bt5g · Answer

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

Thanks

Els Vercauteren · Answer

Thanks, it works.

David Niro · Answer

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