Vlook up in VBA

[sara101]

Ok

Here goes...

So I have quite a complex userform. Basically I have a start time and an end time which gives a Time on Site in Hours,
The user inputs and clicks a Format button "Command Button2" and its automatically calculates the time in Hours & Mins.
Formula I am using is

Private Sub CommandButton2_Click()
UserForm1.txtvdt.value = Format(txtvdt.value, "hh:mm:ss AM/PM")
mytime1 = TimeValue(UserForm1.txtvat.value)
mytime2 = TimeValue(txtvdt.value)
mytime3 = mytime2 - mytime1
UserForm1.txthrs.value = Format(mytime3, "hh:mm")

Ok So now I need this Time Different
To look up on a another sheet the price it will cost to be on site for that period of time?
And possibly also convert the total time to just minuets

Example

Time on Site "txthrs" "01:10" [1hour and 10Mins]
Look up on sheet 3 Named "Waiting time sheet"
and the data is in Column A, B, C
Column A being the times in txthrs format
Column B being the Price in £
Column C Time converted to Min's

So I need my text boxes
txtmins
txt amount
To automatically find the values based on my txthrs Total

Please can someone help as I know this is just a simple lookup.
But its driving me crazy

[pareshj]

Hi,

Please attached sample workbook and expected output.

Regards,
Paresh J

[sara101]

Sample Userform.xlsmSee attached Sample Workbook

You can see the tab Waiting time Cost
And the userform
See Vehicle Detail Frame

See right the 3 text boxes

Time on Site - Automatically calculated by my previous formula
Mins on Site - Need to look up based on Time on Site in Waiting time sheet Column C [3]
Amount - Need to look up based on Time on Site in waiting time sheet Column B [2]

[jolivanes]

sara101.
Could you please read the forum rules. In this case #3 regarding code tags.