Date/Time parsing and calculation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Terry Pinnell <terrypinDELETE@xxxxxxxxxxxxxxxxxxx>
Date: Mon, 21 May 2007 14:16:17 +0100

I'm struggling with this one and would appreciate some help please. I
have a Start Time fixed in C3, 10:20, in Custom format hh:mm. IOW,
getting on for half past ten in the morning. In the body of the
worksheet I have

Col A Col B
Filename Time from Start
----------------------------------- ---------------
20050813-105501-KennetAvonJoins.JPG
20050813-112231-ReadingHenley.JPG
20050813-114837-Sonning Lock.JPG
etc

Each filename is prefixed with date and time, e.g.
20050813-105501 is about 10:55 on 13th August 2005 (I'm ignoring
seconds).

I want to calculate and enter the times from start in Col B, like
this:

Col A Col B
Filename Time from Start
----------------------------------- ---------------
20050813-105501-KennetAvonJoins.JPG 0:35
20050813-112231-ReadingHenley.JPG 1:02
20050813-114837-Sonning Lock.JPG 1:46
etc etc

Could someone help me derive the correct formula please?

--
Terry, West Sussex, UK

.

Follow-Ups:
- Re: Date/Time parsing and calculation
  - From: Terry Pinnell

Prev by Date: Re: VB Crash - Little Bit Of Fun
Next by Date: Re: how do i create a percantage formula in a cell?
Previous by thread: Re: VB Crash - Little Bit Of Fun
Next by thread: Re: Date/Time parsing and calculation
Index(es):
- Date
- Thread

Relevant Pages

Re: Date/Time parsing and calculation
... have a Start Time fixed in C3, 10:20, in Custom format hh:mm. ... IOW, ... Could someone help me derive the correct formula please? ... expect there's a neater solution though! ...
(microsoft.public.excel.misc)
Re: Date/Time parsing and calculation
... have a Start Time fixed in C3, 10:20, in Custom format hh:mm. ... IOW, ... Could someone help me derive the correct formula please? ... expect there's a neater solution though! ...
(microsoft.public.excel.misc)
Re: Date/Time parsing and calculation
... have a Start Time fixed in C3, 10:20, in Custom format hh:mm. ... IOW, ... Could someone help me derive the correct formula please? ... expect there's a neater solution though! ...
(microsoft.public.excel.misc)
Re: Date/Time parsing and calculation
... Toppers wrote: ... "Terry Pinnell" wrote: ... have a Start Time fixed in C3, 10:20, in Custom format hh:mm. ... IOW, ...
(microsoft.public.excel.misc)
Re: Planting out hostas
... "Sacha" replied to a message: ... IOW, would they benefit from being potted up and given ... it is struggling, really struggling! ... What mix of potting compost would you suggest for a hosta's wellbeing? ...
(uk.rec.gardening)