Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting time-frames | Excel Discussion (Misc queries) | |||
Counting time | Excel Worksheet Functions | |||
Counting Time | Excel Worksheet Functions | |||
counting time slots | Excel Worksheet Functions | |||
Counting Cells with time value | Excel Discussion (Misc queries) |