Forum Discussion
Solved
Calculating subtotal when references range are time interval (decimal figures)
Hello everybody! I want to use the group function to calculate subtotal for an specific range of data. The thing is: my references column are minutes (decimal figures). I want excel group interval of ...
You could add a helper column with formulas such as =INT(A2) to return the whole minutes, and group on that.
In Spanish: =ENTERO(A2)
You could add a helper column with formulas such as =INT(A2) to return the whole minutes, and group on that.
In Spanish: =ENTERO(A2)
- Thanks Hans!
