Insert formulas in VB

[ageless]

I am fairly new to VB

I want to enter a formula in VB but don't know how to proceed.

The formula I use in Excel is as follows

=IF(B2="A",M2*20.27)+IF(B2="B",M2*15.96,0)

How can I write a formula to make the same thing work in VB

Any help would be greatly appreciated.

TX

[.paul.]

you use if,then,else,end if blocks:

if something = something then
    doSomething
else
    doSomethingElse
end if

[ageless]

I tried the following

Private Sub UserForm_Click()
If txtFinish - txtStart >= 6.1 Then
txtLunch = 0.5
Else
txtLunch = 0
End If


End Sub

This is a string that automatically adds lunch if time from Start to Finish exceeds 6 hours.

Any ideas???

TX

[.paul.]

it looks like you're trying to perform arithmetic on strings. try using timespans:

Dim startTime As String = "05:45:00"
Dim ts1 As TimeSpan = TimeSpan.Parse(startTime)
Dim endTime As String = "12:00:00"
Dim ts2 As TimeSpan = TimeSpan.Parse(endTime)
MsgBox((ts2 - ts1).ToString)