Try using a pivot table. Your question if a little vague, but if I understand
correctly you want to be able to group together similar time periods from
different dates. Place the hours in the left hand column and the prices in
the middle of the table. If you wnat to you can also add the dates to the
left hand column and group your dates into months, quarters, ... If this is
of interest to you and you need more help just let me know...
--
HTH...

Jim Thomlinson


"nikolasp" wrote:


I have a three columns with the following information

Date Hour Price
11/1/05 0 10
11/1/05 1 15
11/1/05 2 12