problem with replacing values formatted as "time"

[inglese]

Hi All,

Can you please help me with one issue.
I`m trying to use excel macro to replace some values. The problem is that the values I want to replace are "time" formatted (hh:mm:ss) and the following command fails (actually do nothing):

Please Login or Register  to view this content.

But in opposite way it works (replacing "time2sleep" to "23:37:00")

Thank You in advance for answers.

[TMS]

Please Login or Register  to view this content.

Time values are numbers representing a fraction of a day ... so you won't find a text string: "23:37:00". You have to convert it to a time.


Regards, TMS

[inglese]

its working perfect^^

thx

[TMS]

You're welcome. Thanks for the rep.