Currently Being ModeratedNov 2, 2012 9:48 AM (in response to Anthropy)
Whether you set the date/time cell format to mm:ss from the pull down menu, or create your own custom cell format, the count and sum functions will return 0.00, because they expect to operate on numerical, not date/time data.
Instead, set the cell formatting to mm:ss for all cells. In the summation cell, you will need the following expression:
=(A2 + A3 + An)
The following screen captures will help.
Currently Being ModeratedNov 2, 2012 10:14 AM (in response to Anthropy)