Hi Doug, As Ashish said, it would be very diffcult to understand these type of data related to Time & Date and that too with a reading of a written para.. So please send out that file as well ...
Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Fri, Mar 20, 2009 at 8:08 AM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Jake, > > Can you please provide us with the dummy data workbook? It's not 100% > clear and providing any solution in such a case doesn't worth much. > . > . > . > . > . > ------------------------------------------------------------------------ > For more tips, tricks, downloads and problem solutions: visit --> > http://www.excelitems.com > ------------------------------------------------------------------------ > Regards > *Ashish **Jain* > Analyst, CSC Australia > Microsoft Certified Application (Excel) Specialist > Technical Trainer - Excel and VBA > Author -> www.excelitems.com > +91-9999-40-48-43 > --------------------------------------------------------------------------- > --------------------------------------------------------------------------- > > On Mar 20, 2:23 am, Jake <doug_jacob...@intuit.com> wrote: > > Here's the setup: > > 1. In column A I have date/time stamps. > > 2. In column B I have text entries associated with the time stamps. > > These > > entries vary but each day starts with a date/time stamp of "System > > Login" and > > ends with a stamp of "System Shutdown". Kind of like a time clock > > situation. > > 3. I pull the start times with a VLOOKUP that looks for "System Login" > > and the > > stop times with a VLOOKUP that looks for "System Shutdown". If it > > doesn't find > > them, it enters "Null". > > 4. Now I've got columns C & D with 100 rows that say either "Null" or > > have a > > date/time stamp. > > 5. I now have to subtract the date/time values in column C from the > > matching > > date/time value in column D to get the duration of time worked for > > that > > particular day. > > > > The problem is that the start times and the stop times are in > > different rows, > > e.g. I might have the start time for 3/16/09 in C2 and the stop time > > in D6, the > > start time for 3/17/09 in C7 and the stop time in D10, and so on. Does > > anyone > > know of a formula I can enter in column E that will subtract the first > > date/time > > value in column C from the first date/time value in column D, the > > second > > date/time in column C from the second date/time in column D and so on > > down the > > line? Any help greatly appreciated. > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
