How many minutes between two times but with a lookup/index

[jurassicrose]

Hi,

First time posting-

I have two sheets and I need to reference a job number from one sheet to see if it appears on the other sheet and if it does to return the time when that job was started so I can work out how long it took before the job was finished.

My issue is that the job number is say 6108812 or 6108819 for when the job finished and in the sheet that I need to know when it was started the jobs are batched so it will say 6108810-6108820 all started at 9:50:14

Is there a way I can get it to return the value if my job number falls in between the two other numbers.

I hope that makes sense.

Thank you!

 

[AhoyNC]

Maybe something like this:

Excel Workbook
	A	B
1	Job #	Start Time
2	6108812	9:50:14
Sheet1

Excel Workbook
	A	B
1	Job #'s	Start Time
2	6108800-6108809	8:25:00
3	6108810-6108820	9:50:14
4	6108821-6108830	10:05:06
Sheet2