Results 1 to 4 of 4

how to calculate number of sales orders and qty created at given time slots?

Threaded View

  1. 06-23-2014, 12:37 AM #1
    flyingflying
    flyingflying is offline
    Registered User
    Join Date
    06-22-2014
    Location
    australia
    MS-Off Ver
    2010
    Posts
    2

    how to calculate number of sales orders and qty created at given time slots?

    I am trying to calculate number of sales orders and total qty dropped in the system to be processed at below given time slots.Pls find data attached.I would like to identify which time slot has most orders dropped in and which time slot has most qty needs to be processed.



    6am-9am
    9am-12pm
    12pm-3pm
    3pm-6pm
    6pm-9pm
    9pm-5:59am

    Any help wtih this would be greatly appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. booking time slots
    By peter renton in forum Excel General
    Replies: 7
    Last Post: 10-07-2019, 05:49 AM
  2. [SOLVED] Calculate number of days between sales and prior sales date
    By maacmaac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2013, 03:07 PM
  3. Calculate time difference between two orders per customer
    By bobbielin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 02:36 PM
  4. [SOLVED] calculating a time range into predefined time slots
    By DamianWarS in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 07:26 AM
  5. counting time slots
    By Nick in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1