Calculate cumulative elapsed time in Excel?

[Courtney]

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]

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

 

[Courtney]

Thanks, that helped. Since I am trying to capture the elapsed time for many
cells, I used =(B4-B3)+E3

Seems to work!

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

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.

 

[Courtney]

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

Thanks, that helped. Since I am trying to capture the elapsed time for many
cells, I used =(B4-B3)+E3

Seems to work!

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

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]

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

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

Thanks, that helped. Since I am trying to capture the elapsed time for many
cells, I used =(B4-B3)+E3

Seems to work!

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


:

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.