How to summarise time in excel?

March 18, 2011 at 05:47:52
Specs: Windows Vista
For example my current format cell is mm:ss
00:01
01:23
10:34
How do I do the sum? what is the formula?

See More: How to summarise time in excel?

Report •

#1
March 18, 2011 at 12:28:43
How do I do the sum? what is the formula?

=SUM(A1:A3)

MIKE

http://www.skeptic.com/


Report •

#2
March 19, 2011 at 01:53:13
sorry mmcconaghy, but your answer contains some error, because seconds sum up to 60 before changing in minutes.

Report •

#3
March 19, 2011 at 06:57:57
sorry mmcconaghy, but your answer contains some error

I don't think so.

10:34 + 1:23 = 11:57

11:57 + 0:01 = 11:58


I think you should read up on how to do time math:

http://www.cpearson.com/excel/datet...

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question