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
Courtney said:
Thanks, that helped. Since I am trying to capture the elapsed time for many
cells, I used =(B4-B3)+E3
Seems to work!
Jacob Skaria said:
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 said:
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.
try the below formula and format to [ss]
=(A2+B2)-(A1+B1)
--
Jacob
Courtney said:
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
Courtney said:
Thanks, that helped. Since I am trying to capture the elapsed time for many
cells, I used =(B4-B3)+E3
Seems to work!
Jacob Skaria said:
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.