Counting Time

S

Spearhead

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.
 
M

Mike H

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
 
Top