Calculating number of instances occuring in an hour for 24 hours

  • Thread starter Thread starter rp
  • Start date Start date
R

rp

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 > SubTotals feature.

Vaya con Dios,
Chuck, CABGx3
 
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 MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract the 2 Lowest % 3
I need calculated time in a "real number" format 2
time diffrence with 24 hour clock 3
Calulating hours, minutes and seconds 5
How do add time/hours to get answer in hours if Ans>24 2
12 hour shift timesheet calculation 5
Calculate the number of hours in a date/time cell 1
how do I calculate a week days hours with the 24hour clock 5

Back
Top