LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default Date/Time parsing and calculation

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date/time calculation needed Charlie7805 Excel Worksheet Functions 2 September 19th 06 03:54 PM
parsing a date field carriex3 Excel Discussion (Misc queries) 2 August 1st 06 09:30 PM
formula date and time calculation changetires Excel Discussion (Misc queries) 8 June 27th 06 03:01 PM
Ignoring Time in a Date Time Calculation nmp Excel Worksheet Functions 3 November 23rd 05 08:32 PM
time/date calculation bladelock Excel Worksheet Functions 2 November 10th 05 01:11 AM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"