PC Review


Reply
Thread Tools Rate Thread

Calculating flow days help

 
 
Cam
Guest
Posts: n/a
 
      14th Jul 2008
Hello,

I got a query from Access and try to calculate the number of days at several
operation, but not sure how to go about calculating in Excel. In the query I
got the field for order#, workcenter, oper#, finishdate and other. I would
like to calculate number of work days exluding holiday at each workcenter.
sample data:

order# oper workcenter finishdate
0110 5 ABC 1/1/08
0110 10 ABC 1/3/08
0110 20 ABC 1/4/08
0110 30 ZZZ 1/6/08
0110 40 DVD 1/7/08
0110 50 DVD 1/9/08
0110 70 VHR 1/14/08

Results would like to acheive:
workcenter oper #ofdays
ABC 5, 10, 20 4 (1/1/08 to 1/4/08)
ZZZ 30 1 (1/4/08 to 1/6/08: 1/5 & 6 weekend)
DVD 40, 50 3 (1/6/08 to 1/9/08)
VHR 70 3 (1/9/08 to 1/14/08: 1/12 & 13 weekend)

Thanks so much for any help.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Business working days & Cash FLow tr2yhb Microsoft Excel Discussion 2 8th Feb 2011 10:05 PM
Help with calculation flow days Cam Microsoft Access Queries 0 9th Jul 2008 04:33 PM
Conditional Formatting Dates calculating 10 days and 30 days from a certain date Sioux Microsoft Excel Worksheet Functions 2 11th Oct 2007 02:04 PM
Calculating recurring date in following month, calculating # days in that period Walterius Microsoft Excel Worksheet Functions 6 4th Jun 2005 11:21 PM
Calculating # of busn days, not just calendar days, between 2 dates? StargateFanFromWork Microsoft Excel Programming 1 29th Jun 2004 08:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:50 AM.