update/convert data?

[d.]

I need to convert the data of the first column so it looks like the value in
the second column... (the data is a text-string)

0u30 => 00:30
2u => 02:00
1u30 => 01:30
1u15 => 01:15

anyone who can help me

thx

d.

 

[Tom Lake]

I need to convert the data of the first column so it looks like the value
in the second column... (the data is a text-string)

0u30 => 00:30
2u => 02:00
1u30 => 01:30
1u15 => 01:15

anyone who can help me

Here's a function that will do it.

Function StrConvert(test As String)
hh = Right("00" & Left(test, InStr(test, "u") - 1), 2)
mm = Right("00" & Mid(test, InStr(test, "u") + 1), 2)
StrConvert = hh & ":" & mm
End Function

Tom Lake

 

[d.]

Here's a function that will do it.

Function StrConvert(test As String)
hh = Right("00" & Left(test, InStr(test, "u") - 1), 2)
mm = Right("00" & Mid(test, InStr(test, "u") + 1), 2)
StrConvert = hh & ":" & mm
End Function

Tom Lake

thx!