After importing them from camera to PC I always rename my photos and
movie clips with a prefix that shows the date and time, in the format
YYMMDD-hhmmss. This allows convenient sorting and placement when I use
them for making my family DVDs.

Using Excel 2000 I'm now trying to calculate the time gap between
several hundred of these, as shown he

https://dl.dropboxusercontent.com/u/...Formulas-1.jpg

(The photos are from a city bus tour in Madrid. The time gaps, used
with a bus timetable, will help me identify their location on the
route. My next camera must have GPS functionality!)

Q1: Could I get some help on how to build those two formulas please?

Q2: Prompted by Claus's help recently, I'm also trying to re-learn a
bit of the little I once knew about using Excel VBA. I'm starting with
recording (as I baulk at VBA coding, apart from copy/pasting and
simple edits). But so far my efforts to record this have failed.
Perhaps this is a macro that CANNOT be recorded? If not, how would I
proceed please?

I can do it with Macro Express Pro but I'd like to learn how to
achieve it in Excel please.


--
Terry, East Grinstead, UK