Posted to microsoft.public.excel.programming

AndrewC

external usenet poster

Posts: 11

counting instances

I have 2 columns of times. Essentailly, the times are customer in and
customer out times. I want to show "how many customers are here at any given
hour?"

I have a graph with columns for each hour of the day. I want to populate
that graph. For example, if 4:30 pm falls between the 2 times, count one for
the "4-5pm" column on the graph.

Any ideas? I have about 8,000 lines of data. THANK YOU!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Counting Instances	saman110 via OfficeKB.com	Excel Programming	3	March 5th 08 09:24 PM
Counting Consecutive Instances	carl	Excel Worksheet Functions	3	September 24th 07 07:08 PM
Counting instances in string	John in Wembley	Excel Discussion (Misc queries)	11	September 18th 07 06:51 PM
Counting Multiple Instances	Curtis	Excel Worksheet Functions	3	January 31st 07 06:22 PM
Counting Instances of a Value?	Neil[_17_]	Excel Programming	2	December 5th 03 08:36 PM

All times are GMT +1. The time now is 10:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us