Submitted by viking on 2022/04/17 18:24

I have a ToDo Grid with ToDo items that is filtered for some date (e.g. Today). The items are not subitems.
Each item has a number field to specify the task time.

1. Is it possible to calculate the total time for all the tasks that are shown in the Grid? (The sum could be shown in separate "total" column that would show the running total of all items.)

2. instead of specifying everything in minutes, e.g. 270 for a task that will take 4h 30min, I would like to specify exactly that; 4h 30 min. Maybe I will need to use a text field and then use a script to convert to minutes before summing..?

Comments

Hi Viking,

  1. There is no running total column (because item position is ill-defined). You can do this if you link Excel to your grid and calculate the running total there. Also, instead of some number field, I recommend using the built-in field ItemDuration. That way, if you ever want to show it in the calendar, the task length would be shown correctly
    To compute the day's total, two options: (1) Select column and right-click > Info, or (2) Use Excel or the built-in Pivot Table view
  2. A text field + some user code would work very well indeed
How do I ?