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.

2 Answers 2


This now seems to work for me:

WA41416 example

  • Unfortunately, it only works if the sum is less than 24 hours. If the sum is more, it shows the sum modulo 24 hours which is not very practical.
    – Futal
    Commented Oct 6, 2022 at 6:37

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
    Commented Mar 12, 2013 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
    Commented Mar 12, 2013 at 12:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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