Time Duration between Slides

[murviper]

I record our church sermon, our Pastor gives me a copy of his powerpoint presentation which I convert to JPG in order to import them into Final Cut Express. I need to know how long each slide will be (they could vary from a short time to a very long time).

what I do is record in a spreadsheet

Column A - slide #,column B - Start time of slide, column C - difference between Slides (duration in terms of Min & Sec.)

Not sure how to set it up.

 

[murviper]

I pick the time point of the Slides from either my camcorder or the audio recording.

 

[murviper]

Some one must have an idea on how to do this?

 

[shg]

To get the time between slides, just subtract the smaller time from the larger.

 

[murviper]

What format do I put the time between slides as?

 

[shg]

Whatever you like: to see seconds, [m]:ss to see minutes and seconds, ...

 

[murviper]

so I would go to format Cells and enter ?
Please be very specific
thanks

 

[murviper]

slides	Time	Difference
1-1	00:00
1-2	3:28	3:28
1-3	3:58	0:30

This is how I would like it to look
a typical sermon could be as long as 30 - 40 minutes.
and have 10 - 20 different slides.

 

[murviper]

Please someone must have an idea on how I should format columns B & C. for minutes & seconds.

 

[murviper]

Whatever you like: to see seconds, [m]:ss to see minutes and seconds, ...

I tried this but I get some ridiculous number that does not make sense to me.