Click here to Skip to main content
14,927,434 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello,
I am looking for a list of the standard time zones in Excel format. I have a developer writing a php application and they want to give the user a drop down to select their time zone. I've been tasked with getting a spreadsheet to populate the drop down. The time zones that Windows displays when you double click the clock is what I'm looking for. This seems like a good standard list to use.

I tried searching for something to download but cant find. I'm sure someone has something. Anybody have a speadsheet I can give to the developer?
Thanks Experts!
Posted

1 solution

Hey!!! it looks like you are copy pasting stuffs from various forums out here... for fun???

I found the exact question that you had asked here:
Time Zone list in Excel[^]

Answer to your question is also in that forum:
If the programmer is using PHP, they could use the standard names for the timezones, contained here:
http://www.php.net/manual/en/timezones.php

That's the list of all valid PHP timezones. You could simply copy those, put each name on it's own line, and give that to the developer in excel or text-file format. If you wanted more details, you could check out the source:
http://www.twinsun.com/tz/tz-link.htm
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900