P

#### Polly

stop time and elapsed time. I need to know how much of the elapsed time

falls between set times elsewhere in the spreadsheet.

Ex: Set times are 07:00 and 15:00

Start time = 14:03

End time = 15:13

Elapsed time = 70

The question I need to answer is, how much of the elapsed time falls between

7:00 and 15:00 and how much falls outside. So the answer is (doing the math

in my head ) is 57 minutes inside and 13 minutes outside.

But I need to do this for hundreds of rows of data and can't seem to come up

with a formula that works.