+ Reply to Thread
Results 1 to 2 of 2

Peak Hour of Sales Calculation

  1. 04-27-2023, 06:02 AM #1
    Krishna111
    Krishna111 is offline
    Registered User
    Join Date
    04-27-2023
    Location
    Dubai
    MS-Off Ver
    365
    Posts
    1

    Peak Hour of Sales Calculation

    Hi Everyone,

    Could you kindly help on creating a formula that gives an hourly time slots and total of sales falling in their respective time slots.

    I have attached the sample file.

    Millions of thanks!!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-27-2023, 08:00 AM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Peak Hour of Sales Calculation

    Welcome to the Forum Krishna111!

    First we have to change the data in column A to time values. Your values are text.

    Then we use SUMIFS to add them up.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Calculation of Peak license usage in a given interval
    By yskreddy123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2018, 03:29 AM
  2. [SOLVED] Find peak days of sales
    By rockell333 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-28-2017, 05:27 PM
  3. Optimization to Find Peak Hour [Ideally in PowerPivot]
    By lsbraun in forum Excel General
    Replies: 0
    Last Post: 06-30-2017, 03:25 PM
  4. Formula to extract the highest peak date and peak times from a consolidated report
    By Shellybelly in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-01-2015, 12:02 PM
  5. Need auto updating calculation of daily sales needed to meet monthly sales goals
    By mmaibl2011 in forum Excel General
    Replies: 2
    Last Post: 10-17-2013, 11:52 AM
  6. Make peak values move to low value region - Peak Lopping - HELP!
    By gottabarra in forum Excel General
    Replies: 5
    Last Post: 05-18-2013, 11:59 AM
  7. [SOLVED] How do I set up a sales forecast to predict sales per hour, when .
    By Greg in forum Excel General
    Replies: 4
    Last Post: 04-17-2005, 07:06 PM

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