Show Bid Request Time Breakdown Bid Request Id: 127 Bookmark in my 'To Do' list Posted by: Bill Trudell (1 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Unverified Approved on: May 14, 2001 2:10:11 PM EDT Bidding Closes: May 28, 2001 2:10:11 PM EDT Viewed (by coders): 2401 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Unknown Bidding Type: Open Auction Categories: Web, Windows, Database, Language Specific, Platforms, Visual Basic Enter chat room for this bid request (0 active users at Sep 6, 2003 2:59:15 AM EDT) Description: calculate total hours worked by staff and then break hours down to total number of hours worked in a given shift. The data files can be found at ........................ ftp://seniorspectrum.com/billftp/Ru/ ........................ Bridges_Scheduling_v4 is linked to Bridges_Data_v4. The query: AqryConfirmation_Detail_NEW has the applicable tables as well as fields to use..................... The program can be opened and viewed by opening the form frmMainClientForm . . This is the microsoft reference for doing this.......... http://msdn.microsoft.com/library/periodic/period99/hours.htm Deliverables: The deliverable will be a function I can use in any query or report to give me the time breakdown results of the four shifts used. 7am - 6pm, 6pm - 10pm, 10pm - 12am, 12am - 7am. Special Conditions / Other: As soon as possible. I already have a function which will give me total hours worked. it is found in one of the modules. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Robbin (1 ratings) in Clinton, Maryland United States Bid id: 136   $45 (USD) May 15, 2001 9:28:50 AM EDT  10 (Excellent)     I can deliver this as a VBA module or wrap a VB front-end around the whole thing. If you want a VBA module only, I can deliver in 4 days. If you want a VB front-end, I can deliver in 6 days after receiving GUI specifications.