Get Time !!!!!

[aryan_hr]

Hi,

I want to get the current system time in my program. I use Time function. But the language is not English, therefore it returns time with some special characters.
How can I get time in Engilsh format????

best wishes

 

[yosi]

Hello from Israel
Hebrew language is the same as Arabic language, from right to left
in Windows
press Start, Control pannel , international look there
This message was edited by yosi on 2002-10-26 02:38
This message was edited by yosi on 2002-10-26 02:52

 

[aryan_hr]

Dear yosi,
Thanks for your reply,
but I want to get time in English format in my program without any changing in language bar.
any help???

best wishse for you and your family
Hamid From Iran

 

[yosi]

Hi Hamid

its very difficul to give you an answer if the problem comming from language
the formats in english are -
HH:MM:SS
press ctrl+1, choose number, in the type box enter the format

you may also use key board shortcut-
ctrl+shift+: to enter current time

did you download this add-in I built
http://www.mrexcel.com/searchaddin.shtml

try it

 

[tim963]

Yosi, just wondering, what does your search addin do that you can’t do with the search function on the web page?

 

[yosi]

you can search directly from any cell in Excel
just enter any text into any cell, select the cell and click the icon or press Ctrl+E

 

[aryan_hr]

Dear yosi,
thanks for your reply.
I think I found a solution for my problem.
I got the system time in 24 hours format by API function and then changed it to English format.

best wihses
Hamid

 

[aryan_hr]

ooppppssssss

sorry, forgot it.... see this API function:
http://216.26.168.92/vbapi/ref/g/gettimeformat.html

Hamid from Iran