| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum amounts based on date field
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct based on date entered in separate field | Excel Discussion (Misc queries) | |||
| New date based on one date field minus minutes in another field | Excel Discussion (Misc queries) | |||
| Lookup to find the last value based on name and date field | Excel Discussion (Misc queries) | |||
| sum multiple rows based on progressing date field on each row | Excel Worksheet Functions | |||
| Adding amounts based on a conditional date | Excel Discussion (Misc queries) | |||
Threaded Mode
