software

I am trying to calculate number of customers who arrive every hour in a
day for theentire year.

suppose: the computer records the name and info of a person arrived and
stores the time he/she arrived like:

10:27 xyz
10:29 abc
10:45 123

so I want to calculate the total arrivals in an hour from 10:00-10:59
and I want to that for the entire 24 hour period and then for the
entire month for each hour,

Please let me know how could i do it in a faster way using exfel.

Thanks,
RP!It depends on exactly how your data is laid out, but I suggest you look in to
the Data gt; SubTotals feature.

Vaya con Dios,
Chuck, CABGx3
quot;rpquot; wrote:

gt; I am trying to calculate number of customers who arrive every hour in a
gt; day for theentire year.
gt;
gt; suppose: the computer records the name and info of a person arrived and
gt; stores the time he/she arrived like:
gt;
gt; 10:27 xyz
gt; 10:29 abc
gt; 10:45 123
gt;
gt; so I want to calculate the total arrivals in an hour from 10:00-10:59
gt; and I want to that for the entire 24 hour period and then for the
gt; entire month for each hour,
gt;
gt; Please let me know how could i do it in a faster way using exfel.
gt;
gt; Thanks,
gt; RP!
gt;
gt;

RP,

Use a pivot table on your data. Drag the time to the row field, and again to the data field, and
then group the row fields by hour, and you will get an hour-by-hour count.

HTH,
Bernie
MS Excel MVPquot;rpquot; gt; wrote in message oups.com...
gt;I am trying to calculate number of customers who arrive every hour in a
gt; day for theentire year.
gt;
gt; suppose: the computer records the name and info of a person arrived and
gt; stores the time he/she arrived like:
gt;
gt; 10:27 xyz
gt; 10:29 abc
gt; 10:45 123
gt;
gt; so I want to calculate the total arrivals in an hour from 10:00-10:59
gt; and I want to that for the entire 24 hour period and then for the
gt; entire month for each hour,
gt;
gt; Please let me know how could i do it in a faster way using exfel.
gt;
gt; Thanks,
gt; RP!
gt;