Thread: Macro needed for time calculation and auto insert
View Single Post
 
Old 05-16-2015, 08:07 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Ballst, with row 2 being empty, is it reasonable to think you want a blank line above each "NEWCASE" line ?

What is the correct Time Taken result that should be in cell C13 ...... 26 hours 8 minutes 54 seconds ?

What would the end point be for NEWCASE ---> LON/00AM/OLR/2014/0558
that starts on your line 952 ?
Last edited by NoSparks; 05-16-2015 at 10:32 PM. Reason: added third question
Reply With Quote