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.


That's not possible in Google Spreadsheets.

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

  • 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. Mar 12 '13 at 12:55

This now seems to work for me:

WA41416 example

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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