Click here to Skip to main content
15,399,574 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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!

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:

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:

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