Need help with adding time

[maryren]

I've created a formula to determine the lapse of time between two cells (=IF(A3=A2,TEXT(B3-B2,"H:mm:ss"),""). This result is now in column C. I need to sum column C by each change in Column A as well and am not sure how to do it. The "sum" formula is not working. Do I need to change to values, or how can I do this? Also, not sure if I should set up with a SUMIF, or if a Pivot table would be better. Any insight you can offer is appreciated.

A B C D
1 11/7/13 12:39:43 AM 0:11:23 Assuming Column A are the same (1's), sum (Row 1:3)
1 11/7/13 12:51:06 AM 0:02:36
1 11/7/13 12:53:42 AM 0:01:51
2 11/8/13 22:39:00 PM 0:07:03

[Tony Valko]

In your formula, the TEXT function is returning a TEXT string even though it looks like a time value.

You don't need the TEXT function in the formula. Just use:

=IF(A3=A2,B3-B2,"")

Format the cell as h:mm:ss

Then your sum function should work.

[maryren]

That is perfect and so simple, I feel silly for not knowing that. Thanks so much.

[Tony Valko]

You're welcome. Thanks for the feedback!