LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
kg kg is offline
external usenet poster
 
Posts: 1
Default How to use count for calls per hour

I am trying to create a pivot table and chart that will show me the # of
calls per hour by day for a range of dates Aug 1 - Sept 19. My data looks
like this where each line is the date and time of the call:

How do I get a count of the # of the calls per hour by day?

8/1/08 12:48 AM
8/1/08 1:53 AM
8/1/08 2:36 AM
8/1/08 3:24 AM
8/1/08 3:37 AM
8/1/08 4:04 AM
8/1/08 4:44 AM
8/1/08 4:55 AM
8/1/08 4:58 AM
8/1/08 7:02 AM
8/1/08 7:28 AM
8/1/08 7:43 AM
8/1/08 7:47 AM
8/1/08 7:56 AM
8/1/08 7:58 AM
8/1/08 8:13 AM
8/1/08 8:33 AM
8/1/08 9:07 AM
8/1/08 10:28 AM
8/1/08 10:38 AM
8/1/08 10:44 AM
8/1/08 11:10 AM

--
kg
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting from 12-hour to 24-hour format Nathan Excel Worksheet Functions 2 July 15th 08 03:51 PM
Hour Count EliA Excel Worksheet Functions 4 June 25th 08 10:17 PM
How to count hours- and multiply with my wage per hour... Sofus Excel Discussion (Misc queries) 4 February 4th 07 10:34 PM
Count by date and hour ChristiaanV Excel Worksheet Functions 4 August 12th 06 12:26 AM
convert decimal numbers to a fraction of an hour for payroll hour Flower Excel Worksheet Functions 4 February 10th 06 07:46 PM


All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"