Sub Totals : Time (hh:mm)

teknovision · Apr 6th 2004

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.. .

Phil

Anonymous · Apr 6th 2004

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.

Richie(UK) · Apr 6th 2004

Hi Phil,

Try an alternative Custom format:

[h]:mm

HTH

EDIT: thomach = TDQ! ;;)

teknovision · Apr 6th 2004

You rock (replace with favourite music genre), thank you very very much!!!!!

Sub Totals : Time (hh:mm)

Participate now!

Share