Adding all values in subitems

i want to add all the time spent on every subitem to the main item column . say eg
subitem 1 is 2 hours 35 mins
subitem 2 is 3 hours 26 mins
main item column value should be 6 . i wana round up to the hours only.

1 Like


First you have to have the subitems time column summarized in the parent. The easiest way to do that is to select “Show Summary on Parent Item” from the column dropdown menu:

Then the formula would be something like this:

ROUND({Subitems Time Tracking}/3600,0)

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas - Part 3: Dates/Times, Strings and Status