Storing time formats in strings

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

Robert Crandal

Cell "A1" is formatted to accept time data in the format of:

[h]:mm

If I run the following code:

Dim s as String
s = Range("A1").Value
MsgBox s

The message box will display a long floating point number
instead of the time that is displayed in the cell. Is there
a way to store the time that is displayed in a cell into a
string variable??

thnak you
 
Back
Top