Counting Time
I have a task that I do every week. I want to count the number of times I do
this task within a time frame thoughout the year. time frame=0001-0759, 0800-1630, 1631-2359. |
Counting Time
Hi,
I created a simple table of your times in F1 - G3 that looks like this 00:01 07:59 08:00 16:30 16:31 23:59 The assuming your data are in Column A (Task) and column B (Times) try =SUMPRODUCT((A1:A20="MyTask")*(B1:B20=F1)*(B1:B20 <=G1)) this would be for Mytask 00:01 - 07:59 Mike "Spearhead" wrote: I have a task that I do every week. I want to count the number of times I do this task within a time frame thoughout the year. time frame=0001-0759, 0800-1630, 1631-2359. |
All times are GMT +1. The time now is 09:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com