Same response as to Toppers, Bob. Formatting to hh:mm:ss seems to do nothing
but screw things up for me. I have tried all kinds of combos. I just tried
leaving the in and out formatted as general and just the reulst as hh:mm:ss,
but the reult was all zeroes. Grrrr.

"Bob Phillips" wrote:

subtract one from the other and format as hh:mm:ss

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"bobby t" wrote in message
...
I'm trying to find the durations between timecode in and out points. It
seems
like it shoudl be easy using Excel formula, but I can't get it to work.
Either the formatting is wrong, showing me a date, whcih I do not want, or
I
get an answer that goes over 60 in the seconds place.

For example, I want to enter an in point of 02:42:15 (A1) with an out
point
of 02:43:20 (B1) and see a duration of 00:01:05 (C1).

Can anyone help? Thanks!