Sub Totals : Time (hh:mm)

  • Hi there,

    I am trying to add the total amount of time required to perform certain activities by person.

    I have 12 activities per person and there are 8 persons, each of the cells, including the totals per person are formatted (Custom, hh:mm). I then add all of these cells to create a total time for all activities per person. In two cases the total hours show as 03:01 and 1:37. However, by looking at the number of hours per activity I calculated that there totals are actually 27h01m and 25h37m.

    So, how do I get the total cells to display 27:01 and 25:37?

    Any ideas would be very welcome!! Many thanks.. .


  • Select your cell with the total time, and from the tool bar:

    FORMAT > CELLS > NUMBER tab > category CUSTOM > enter [h]:mm in the Type window.

    This will allow hours greater than 23 to display.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!