Counting if Something Occurred During a Time Span

D

Daren

I have start and end time data that I need to investigate to determine if the
time used occurred during the certain time frame of 1700 to 0600 hours. For
example, if the start time was 1300 and end time was 1800, I would need to
know that time was used. Similarly, if the start time was 0400 and end time
was 0700, I would need to know that time was used. I just need to know if
the time was used and not how much time was used. Finally, when dealing with
the time data, there are instances where it will go past midnight. Do the
formulas need to change to take into account the the midnight crossover?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a formula for a Time Sheet. 1
Calculate the median value before a specified list 0
I need Time Range to return Value 4
If statement based on time ranges 2
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA to look for more than 1 key word and highlights 8
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3

Top