Did my solution not work for you? (Or can you not see my post?)

Pete

On Dec 9, 2:46*pm, MikeK wrote:
I'm sorry, I forget to include this is Excel 2003. *Thanks for any help..



"MikeK" wrote:
I have two columns. *Column A is a date time column. *Column B is an amount
column. *I want to calculate the amounts by the hour and place the hourly
totals in Column C and the date time of that hour in Column D. *Below is an
example of the data and how I would like Column C and Column D to look.

Column A * * * * * * * * * Column B * * * * Column C * * * * * *Column D
DATE * * * * * * * * * * * *AMOUNT * * * *TOTALS/HR * * * * * *DATE
01/01/2009 01:10:10 * * * *50 * * * * * * * * * * 75 * * * * * * *
01/01/2009 01:00:00
01/01/2009 01:20:05 * * * *25 * * * * * * * * * * 10 * * * * * * *
01/01/2009 02:00:00
01/01/2009 02:01:00 * * * *10 * * * * * * * * * * 45 * * * * * * *
01/01/2009 03:00:00
01/01/2009 03:05:25 * * * *15 * * * * * * * * * * 20 * * * * * * *
01/02/2009 05:00:00
01/01/2009 03:07:59 * * * *30
01/02/2009 05:05:01 * * * *20

I posted this earlier but couldn't find my post. *I guess I did it
incorrectly. *Any help would be appreciated. *If the alignment is skewed
below is the information per column.
Column A * * * * * *
DATE * * * * * * * *
01/01/2009 01:10:10
01/01/2009 01:20:05
01/01/2009 02:01:00
01/01/2009 03:05:25
01/01/2009 03:07:59
01/02/2009 05:05:01

Column B *
AMOUNT * *
50 * * * *
25 * * * *
10 * * * *
15 * * * *
30
20

Column C *
TOTALS/HR
*75 *
*10 *
*45 *
*20 *

Column D
DATE
01/01/2009 01:00:00
01/01/2009 02:00:00
01/01/2009 03:00:00
01/02/2009 05:00:00- Hide quoted text -

- Show quoted text -