Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If I select multiple cells in a Google Spreadsheet, sum or count appears at the lowerright corner according to the data type.

Sum is shown for numbers, and count is shown for characters, dates or times. But I'd like to see 'sum' for times. How can I change this setting?

I know I can do this using 'sum' function in a separate cell, but I would like to see this more conveniently.

share|improve this question

That's not possible in Google Spreadsheets.

How are you planning on making the date summation? To return a date?

share|improve this answer
I'm using this spreadsheet to manage time. So I need to sum up times. – user67275 Mar 12 '13 at 12:51
@user67275 Then you must use formulas to do so. The answer remains unchanged: what you're asking for isn't possible. – Jacob Jan Tuinstra Mar 12 '13 at 12:55

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.