Sometimes you’re working with a large amount of data, and you only want the numbers to be added to a total. This function will convert all non numbers to 0 and add it to the total you pass in.
 

Function convertHours(sHours As String, dHours As Double) As String
If dHours = 0 Then
sHours = "0"
Else
If Not IsNumeric(sHours) Then
sHours = "0"
End If
End If
convertHours = sHours
End Function

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s