Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting in ranged intervals
I'm working with a log that contains Outlook exchange data
on a minute basis. I would like to get the sum of the data for every hour. For example, get the sum of data from 8:00 am to 8:59 am, and from 9:00 am to 9:59 am, and so on. Is this possible in excel? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting in ranged intervals
Use a pivot Table and group on hour.
-- Regards, Tom Ogilvy wrote in message ... I'm working with a log that contains Outlook exchange data on a minute basis. I would like to get the sum of the data for every hour. For example, get the sum of data from 8:00 am to 8:59 am, and from 9:00 am to 9:59 am, and so on. Is this possible in excel? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting in ranged intervals
Hi
if your time is in col. A and the values in col. B try =SUMPRODUCT(--(A1:A1000=TIME(9,0,0)),--(A1:A1000<TIME(10,0,0)),B1:B100 0) -- Regards Frank Kabel Frankfurt, Germany wrote: I'm working with a log that contains Outlook exchange data on a minute basis. I would like to get the sum of the data for every hour. For example, get the sum of data from 8:00 am to 8:59 am, and from 9:00 am to 9:59 am, and so on. Is this possible in excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Adding Time based on a name ranged | Excel Discussion (Misc queries) | |||
Named ranged selection problem | Excel Worksheet Functions | |||
Multiple Fields In Multiple Ranged Pivot Table | Excel Discussion (Misc queries) | |||
Counting cells with intervals | Excel Worksheet Functions | |||
Vlookup - Using a named ranged for col_index_num | Excel Discussion (Misc queries) |