Solved: Time as string with decimals?

[Ago]

I try to get the Value of Column R as in the macro shows with the decimals.
Is that even possible?

[VBA]
Sub bbbasd()
MsgBox Format((Range("R365").Value), "nn:ss:00")
End Sub
[/VBA]

It "works" in Excel but not in VBA.
I have tried str(), Timevalue and just Range(), but none of them seems to work.

Any ideas?

[SamT]

[vba]Sub bbbasd()
Const FormatStyle As String = "mm:ss.nn"
MsgBox (Format((Range("A1").Value), FormatStyle))
End Sub[/vba]

[snb]

[vba]Sub M_snb()

MsgBox Range("R365").Text
End Sub[/vba]

[Aflatoon]

You can also use the Text worksheet function:
[vba]MsgBox Application.Text(Range("R365").Value, "mm:ss.00")
[/vba]

[Ago]

Thank you all for the help!
It worked!