Time Between two Times

[sdruley]

Oh, these supposedly simple things are driving me nuts.
I have two times on the same day:

9:55:22
9:58:44

How do I calculate the number of total seconds between these times? (202 seconds)

Your assistance is always appreciated.

Steve

 

[T. Valko]

Oh, these supposedly simple things are driving me nuts.
I have two times on the same day:

9:55:22
9:58:44

How do I calculate the number of total seconds between these times? (202 seconds)

Your assistance is always appreciated.

Steve

Try this...

=(A2-A1)*86400

 

[p45cal]

..and if you need only see the number of seconds rather than use them in another calculation try:
=A2-A1
and format the cells using a custom format:
[ss]

The cell's value will actually be:[TABLE="width: 145"]
<tbody>[TR]
[TD="width: 145, align: right"]0.002337963[/TD]
[/TR]
</tbody>[/TABLE]

 

[smkyle]

another possibility is to take advantage of the minute() and second() functions. So you could do A3=A2-A1

60*minute(A3)+second(A3)

 

[sdruley]

Thank you gentlemen. All suggestions worked fine but I did find smkyle's offering fit my situation best.
Your time is appreciated.

Steve

 

[T. Valko]

Thank you gentlemen. All suggestions worked fine but I did find smkyle's offering fit my situation best.
Your time is appreciated.

Steve

Good deal. Thanks for the feedback!