how to convert time eg 11:33:59 to text within a macro

[oldbrewer]

hello everybody and thanks in advance - I wish to use a macro to determine present time using now() and then convert that value to text within the macro. I do not wish to use helper cells on the spreadsheet. I am using excel 2000.

 

[Rick Rothstein]

This would work...

Dim t As String
t = [TEXT(NOW(),"hh:mm:ss.000")]
MsgBox t

Note: I used 3 zeros because you did, however, you can only retrieve 2 decimal places maximum on the seconds.

 

[Joe4]

I am not very good with VBA - retired 16 years ago, 78 years old. Never used message boxes. Can I just use the middle line beginning t = ?
Thanks for trying to help. I failed with format(now(),"hh:mm:ss.000")

You don't need to use the MsgBox.
That is just there for demonstration purposes, to show what it is calculating/returning.
The "t" variable would be all that you need.