Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date/time calculation needed | Excel Worksheet Functions | |||
parsing a date field | Excel Discussion (Misc queries) | |||
formula date and time calculation | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time/date calculation | Excel Worksheet Functions |