Hello,

I want to build a board to plan workload and track the time spent per task.

I have the following columns:

Numbers - representing the Planned hours.

Time tracking -

Formula to subtract the previous and see the excess time.

```
ROUND(SUM({Kapazität}, -{Time Tracking#Hours}),2)
```

Whit this formula, I got the answer but not in the right format. (look at the minutes).

```
IF({Kapazität} >= {Time Tracking#Hours}, TEXT(MULTIPLY(SUM(MULTIPLY({Kapazität},60),-{Time Tracking#Minutes}),60),"h:mm"),"OUT OF TIME")
```

With this second formula I format the result to display “hh:mm”, the summary of the column treats the results as text and does not give me a sum of all the remaining hours.

Is there a way I can have both? a properly formatted result and a column summary?

Thanks, Have a nice day!