Forum Discussion

Ana33170's avatar
Ana33170
Copper Contributor
Nov 01, 2021
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 data, for example: sum from 0,0 min to 0,99 min and at the same time sum values for every data column (in my case, I have 5 “companies” and their production lot for every interval of time). in conclusion, I need group data row in whole numbers of interval of time (min 0 (sum from 0,00 to 0,99), min 1 (sum from 1,00 to 1,99)…).
I’m working in Excel for Mac. Version 16.54. (MacBook Air 2020).

Thanks!!!!
  • Ana33170 

    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)

3 Replies

  • Ana33170 

    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)

Resources