Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

1 Answer 1

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.