Hi all,

I was hoping someone could help with me with a formula.
I have a worksheet with 6000 lines exported from a room booking
program called Syllabus Plus.
Result required- count the number of bookings made each hour from 8am
-6pm Monday to Friday.
So on each line all I have is the time of the booking and the day (and
other data which I remove).
Presently I sort all the data into day and time of booking then do a
sum for each group of bookings.

What I would like is a formula that adds all the lines that say Monday
8:00, Monday 9:00, Tuesday 4:00 etc then I can turn these results into
a graph.
Any Uber Geek that can help would be much appreciated.

Kindly
Dave (Chubbybat)

Use a pivot table

See http://www.contextures.com/xlPivot01.html
and http://www.peltiertech.com/Excel/Pivots/pivottables.htm


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"chubbybat" wrote in message
...
Hi all,

I was hoping someone could help with me with a formula.
I have a worksheet with 6000 lines exported from a room booking
program called Syllabus Plus.
Result required- count the number of bookings made each hour from 8am
-6pm Monday to Friday.
So on each line all I have is the time of the booking and the day (and
other data which I remove).
Presently I sort all the data into day and time of booking then do a
sum for each group of bookings.

What I would like is a formula that adds all the lines that say Monday
8:00, Monday 9:00, Tuesday 4:00 etc then I can turn these results into
a graph.
Any Uber Geek that can help would be much appreciated.

Kindly
Dave (Chubbybat)