Perfect. Thanks, Steve On Apr 19, 10:32 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Steve, > > If we leave the weekend part, your problem is solved. > You can use pivot table. Put work order in Row field and > Count of Dates in Data field. Problem is solved (partially). > > For more tips, tricks, downloads and problem solutions: visit > -->http://www.excelitems.com > ------------------------------------------------------------------------ > Regards > *Ashish **Jain* > Analyst, CSC > Microsoft Certified Application (Excel) Specialist > Excel and VBA Trainer > Author ->www.excelitems.com > +91-9999-40-48-43 > ------------------------------------------------------------------------------------- > ------------------------------------------------------------------------------------- > > On Apr 2, 6:39 pm, Steve <sspatri...@yahoo.com> wrote: > > > > > I've come across a problem where I'm extracting data on clocked hours > > from our > > MRP system and don't quite know how to approach it. In column "B" I > > have these > > Work Order numbers. The Work Order numbers appear in this column for > > every > > person that clocks in against the Work Order. Therefore, the same Work > > Order > > could appear anywhere from one time to roughly 10 times. I have the > > sheet > > sorted by this column so that the multiple instances of the Work > > Orders appear > > all together. Over in column "F" I have the dates in which each person > > clocked > > in against each Work Order. For future repeat project planning, > > somehow I need > > to get at the number of days that each Work Order was actually clocked > > in on > > from start to finish. > > > If any of the clocked in dates are on a weekend, I need > > to include that day in my total number of days. If there was no > > activity on > > either a Saturday or a Sunday, then I need to subtract that day from > > my total > > number of days. > > > Any help would be greatly appreciated. > > > Thanks, > > > Steve- Hide quoted text - > > - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
