IF statement to calculate time usage in specific time bands
Here is an amendment if A2 and B2 are both before or after the
interval 7-10am:
=MEDIAN(B2,C2,D2)-MEDIAN(A2,C2,D2)
where C2 and D2 are 7:00 and 10:00.
On Jan 30, 1:50 pm, "Bob Phillips" wrote:
=MIN(B2,TIME(10,0,0))-MAX(A2,TIME(7,0,0))
--
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Daren" wrote in ...
I have data that shows stop and end points for certain procedures. For
example, something starts at 8:00 am and ends at 12:00 pm, which is a
total
of 4 hours. What I need to know is how much of this time occurs in a
particular time band, say 7 am to 10 am, which would be three hours. I
need
to figure out a way to write an IF statement that will capture this. The
problem I have so far is that the IF statement I've written works for many
of
the time bands, but it's not picking up time usage for some reason in the
7
am - 1 pm range, when time is definitely being used. Is there some other
way
I can write the IF statement or some way I should revise it so that it'll
pick up every calculation of time usage in a particular time band?
|