Thread: Macro needed for time calculation and auto insert
View Single Post
 
Old 05-20-2015, 04:57 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
ballst, please don't quote entire posts, it's not necessary.

I've attached the file I've been playing around with for the example data you posted.
The particular end point you specified seems to exist in every NEWCASE except for the one I asked about. Whether it's really what you would be looking for in all cases, I don't know.

Any way, have a look at the macros in this file, perhaps there is something you will be able to adapt.
Just hit Alt + F8 to bring up the macro dialogue and you can run the macros.

Good luck with this project
NoSparks
Attached Files
File Type: xls TimeTaken_01.xls (206.5 KB, 11 views)
Last edited by NoSparks; 05-20-2015 at 05:21 PM. Reason: added the Alt F8 part
Reply With Quote