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? |
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? |
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? |
All times are GMT +1. The time now is 10:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com