Get Time !!!!!

aryan_hr

Board Regular
Joined
Feb 19, 2002
Messages
222
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

yosi

Board Regular
Joined
May 14, 2002
Messages
67
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

Board Regular
Joined
Feb 19, 2002
Messages
222
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

Board Regular
Joined
May 14, 2002
Messages
67
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

Board Regular
Joined
Aug 20, 2002
Messages
58

ADVERTISEMENT

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

yosi

Board Regular
Joined
May 14, 2002
Messages
67
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

Board Regular
Joined
Feb 19, 2002
Messages
222
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
 

Forum statistics

Threads
1,144,127
Messages
5,722,634
Members
422,450
Latest member
Springbok

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top