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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
