Problem with subitems and time

[santus]

I have a colum that tracks the time of subitems and a column that tracks time of other items
I want to have a third column that sums both but i have problems with numbers and formulas

RIGHT(“0” & INT({Subitems EA Time}+{Time#Hours}), 2) &"h "

[BiancaT (Bianca Taylor)]

Hey @santus,

Just to confirm we are on the same page, are you interested in summing the total subitem column with the time tracked in the associated parent item (for each item)?

I want to be sure I am understanding your current set up and formula

[santus]

Hi there Bianca, yes correct , and can’t understand why at the sum column I still see 0

[BiancaT (Bianca Taylor)]

Can you give this formula a go?

({Subitems Time Tracking}+{Time Tracking#Seconds})/60

It’s important to note, that for the formula to work correctly the time-tracking will need to be paused!

[santus]

@BiancaT

({Subitems Time Tracking}+{Time Tracking#Seconds})/60

Thank you a lot, it worked just had to add /60 to show in hours