Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Calculate cumulative elapsed time in Excel?

14 views
Skip to first unread message

Courtney

unread,
Dec 14, 2009, 9:03:01 AM12/14/09
to
In column B, I have the time in hh:mm:ss. In column E, I am trying to
calculate the cumulative elasped time (ss) of column B. Please advise.

Jacob Skaria

unread,
Dec 14, 2009, 9:08:01 AM12/14/09
to
Use the usual SUM() formula and format the formula cell to

FormatCells>Custom>Enter:

[ss]

or to display in hour minute format

[h]:mm:ss

--
Jacob

Courtney

unread,
Dec 14, 2009, 9:30:01 AM12/14/09
to
Thanks, that helped. Since I am trying to capture the elapsed time for many
cells, I used =(B4-B3)+E3

Seems to work!

Courtney

unread,
Dec 14, 2009, 9:34:01 AM12/14/09
to
This doesn't work when the day changes. See example:
Date Time
8/14/2007 23:58:25
8/14/2007 23:58:55
8/14/2007 23:59:25
8/14/2007 23:59:55
8/15/2007 0:00:25
8/15/2007 0:00:55
8/15/2007 0:01:25
8/15/2007 0:01:55
8/15/2007 0:02:25
8/15/2007 0:02:55

Jacob Skaria

unread,
Dec 14, 2009, 11:32:01 AM12/14/09
to
With data as below

Col A Col B


8/14/2007 23:59:55
8/15/2007 0:00:25

try the below formula and format to [ss]
=(A2+B2)-(A1+B1)


--
Jacob

0 new messages