+ Reply to Thread
Results 1 to 4 of 4

Counting data received per hour per day

  1. #1
    Registered User
    Join Date
    11-30-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    2

    Counting data received per hour per day

    Hi to all,

    I'm having a difficulty counting the entries we are receiving per hour based on the data provided by our system.

    What I'm hoping to get is the information for the received entries per hour per day.

    I appreciate the help. Please see attached file for the sample data.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Counting data received per hour per day

    Hi and welcome to the board.

    Try a Pivot Table and group by hours

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Counting data received per hour per day

    Pl see attached file
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-30-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Counting data received per hour per day

    Thank you very much for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1