<HTML> <HEAD> <!-- The block of META tags is required by Homepage Studio --> <!-- to identify this file as created by Freeform Editor. --> <!-- Please do not remove them, but feel free to append --> <!-- them with your personal data below. Meta tags help --> <!-- search engines identify the content of your page. --> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="keywords" CONTENT="Excel World Clock UK GMT Time Difference International Dialing Code Euro Currency Conversion"> <META NAME="description" CONTENT="Excel is used to show the local date times and time zones in the USA and Japan relative to the time in the UK (GMT)"> <META NAME="author" CONTENT="Ken Matsuoka"> <META NAME="generator" CONTENT="Microsoft FrontPage 4.0"> <TITLE>Excel World Date Time Clock and Time Zones</TITLE> </HEAD> <BODY> <center> <center> <script type="text/javascript"><!-- google_ad_client = "ca-pub-8248528368163939"; /* 728x90 Rectangle Horizontal */ google_ad_slot = "6870862228"; google_ad_width = 728; google_ad_height = 90; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></center> <!-- --> <table> <tr valign="top"> <td> <script type="text/javascript"><!-- google_ad_client = "ca-pub-8248528368163939"; /* 120x600, created 2/3/08 */ google_ad_slot = "9877709725"; google_ad_width = 120; google_ad_height = 600; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></td> <td> <p align="center"> <center> <center> <script type="text/javascript"><!-- google_ad_client = "ca-pub-8248528368163939"; /* 728x90 Rectangle Horizontal */ google_ad_slot = "6870862228"; google_ad_width = 728; google_ad_height = 90; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <p align="center"> </center> </p> <div align="center"> <FONT SIZE=2 PTSIZE=10 FAMILY="SERIF" FACE="Times New Roman" LANG="11">You're the guest No. <!-- Start Bravenet.com Service Code --> <script language="JavaScript" type="text/javascript" src="http://pub20.bravenet.com/counter/code.php?id=369079&usernum=1681046550&cpv=2"></script> <!-- End Bravenet.com Service Code --> since February 26, 2000</FONT></div> <p align="center"> <center><table><tr valign="top"><td> <!-- SiteSearch Google --> <form method="get" action="http://www.google.com/custom" target="google_window"> <table border="0" bgcolor="#ffffff"> <tr><td nowrap="nowrap" valign="top" align="left" height="32"> <a href="http://www.google.com/"> <img src="http://www.google.com/logos/Logo_25wht.gif" border="0" alt="Google" align="middle" width="75" height="32"></a> </td> <td nowrap="nowrap"> <input type="hidden" name="domains" value="http://kenmzoka.tripod.com"></input> <input type="text" name="q" size="31" maxlength="255" value=""></input> <input type="submit" name="sa" value="Search"></input> </td></tr> <tr> <td>&nbsp;</td> <td nowrap="nowrap"> <table> <tr> <td> <input type="radio" name="sitesearch" value="" checked="checked"></input> <font size="-1" color="#000000">Web</font> </td> <td> <input type="radio" name="sitesearch" value="http://excelfan.com"></input> <font size="-1" color="#000000">excelfan.com</font> </td> </tr> </table> <input type="hidden" name="client" value="pub-8248528368163939"></input> <input type="hidden" name="forid" value="1"></input> <input type="hidden" name="ie" value="ISO-8859-1"></input> <input type="hidden" name="oe" value="ISO-8859-1"></input> <input type="hidden" name="safe" value="active"></input> <input type="hidden" name="cof" value="GALT:#008000;GL:1;DIV:#336699;VLC:663399;AH:center;BGC:FFFFFF;LBGC:336699;ALC:0000FF;LC:0000FF;T:000000;GFNT:0000FF;GIMP:0000FF;FORID:1;"></input> <input type="hidden" name="hl" value="en"></input> </td></tr></table> </form> <!-- SiteSearch Google --> </center> <p><center><script type="text/javascript"><!-- google_ad_client = "pub-8248528368163939"; google_ad_width = 200; google_ad_height = 90; google_ad_format = "200x90_0ads_al_s"; google_ad_channel =""; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <p> <center><script type="text/javascript"><!-- google_ad_client = "pub-8248528368163939"; google_ad_output = "textlink"; google_ad_format = "ref_text"; google_cpa_choice = "CAAQidTQgAIaCDFyD7PiBqtPKN2uuIEB"; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></center></P> <center> <iframe src="//www.facebook.com/plugins/like.php?href=http%3A%2F%2Fkenmzoka.com%2FExcelWorldClockUK.htm&amp;width&amp;layout=standard&amp;action=like&amp;show_faces=true&amp;share=true&amp;height=80" scrolling="no" frameborder="0" style="border:none; overflow:hidden; height:80px;" allowTransparency="true"></iframe> <br> <p align="center"><font size="5"> <a href="http://excelfan.com" target="_blank"><img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="50" height-"50">&nbsp;CalendarClockCountdown</a></p> <p align="center"> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <!-- Rectangle Square Big --> <ins class="adsbygoogle" style="display:inline-block;width:336px;height:280px" data-ad-client="ca-pub-8248528368163939" data-ad-slot="2499615394"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script></p> <p align="center"> <i><a href="http://kenmzoka.com/091223MapOahu.htm" target="_blank">Hawaii in world clock, a Google Gadget</a></i> </p> </td><td></td></tr></table> <script src="//sharebutton.net/plugin/sharebutton.horizontal.js"></script> <p align="center"> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <!-- Rectangle Square Big --> <ins class="adsbygoogle" style="display:inline-block;width:336px;height:280px" data-ad-client="ca-pub-8248528368163939" data-ad-slot="2499615394"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script></p> <p align="center"><b><font color="#800080"><span style="background-color: #FFFFFF"><font face="Times New Roman" SIZE="5" PTSIZE="10"><i>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </i></font><font face="Times New Roman" ptsize="10" size="5">Excel World Clock</font></span></font><span style="background-color: #FFFFFF"><font face="Times New Roman" ptsize="10" size="5" color="#800080"> UK</font><font face="Times New Roman" SIZE="5" PTSIZE="10" color="#00FF00">&nbsp;</font><font face="Times New Roman">&nbsp;&nbsp; </font></span></B><FONT COLOR="#000000" SIZE=4 PTSIZE=10><span style="background-color: #FFFFFF">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> </font> <p align="center"> <font face="Times New Roman" color="#000000" size="5" ptsize="10">What's New: <br> <font size="5"> <p align="center"> <font face="Times New Roman" lang="11" size="5" ptsze="10" family="FIXED"><a href="http://excelfan.com/20140726WorldClockTimeZones.xls" target="_blank"> <img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="50" height-"50" >&nbsp;World Clock Time Zones</a> in Excel</font><br> <span style="BACKGROUND-COLOR: #ffffff"><b><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><br> </font></b></span><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED">- July 28, 2014 -</font> </p><br></p> <p align="center"> <font face="Times New Roman" lang="11" size="5" ptsze="10" family="FIXED"><a href="http://kenmzoka.com/20131111WorldClockHawaii.xls" target="_blank"><img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="35" height"32"></a>&nbsp;&nbsp;&nbsp;&nbsp;World Clock for Hawaii </font><br> <span style="BACKGROUND-COLOR: #ffffff"><b><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><br> </font></b></span><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED">- November 11, 2013 -</font> </p><br> <p align="center"> <script type="text/javascript"><!-- google_ad_client = "pub-8248528368163939"; google_ad_width = 728; google_ad_height = 90; google_ad_format = "728x90_as"; google_ad_type = "text_image"; google_ad_channel =""; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></p> <p align="center"> <font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"> <a href="http://excelfan.com/150527WorldClockDelhi.xls" target="_blank"><img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="35" height"32"></a>&nbsp;&nbsp;&nbsp;&nbsp;World Clock for New Delhi <br>Revised with clocks for DST zones </font><br> <span style="BACKGROUND-COLOR: #ffffff"><b><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><br> </font></b></span><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED">- May 27, 2015-</font> </p> <p align="center"> <font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><a href="http://kenmzoka.bizland.com/070201WorldClockDelhi.xls" target="_blank"><img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="35" height"32"></a>&nbsp;&nbsp;&nbsp;&nbsp;World Clock for New Delhi </font><br> <span style="BACKGROUND-COLOR: #ffffff"><b><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><br> </font></b></span><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED">- February 8, 2007 -</font> </p><br> <p align="center"> <font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><a href="http://excelfan.com/070131WorldClockED.xls" target="_blank"><img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="35" height"32"></a>&nbsp;&nbsp;&nbsp;&nbsp;World Clock for New York <br><a href="http://www.bestplaceshawaii.com/tips/big_kahuna/time.html" target="_blank">What is the time difference in Hawaii?</a> </font><br> <span style="BACKGROUND-COLOR: #ffffff"><b><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><br> </font></b></span><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED">- February 1, 2007 -</font> <br><p align="center"><table><tr><th width="6%" valign="top" scope="col"><div align="right"></div></th><td width="92%" align="left"><div align="left"></div></font> </font> <table><caption>March 13, 2007</caption><tr><td><P align="left" style="width: 450px; height: 100px; color: #666666; font-size: 9pt; border: double #999999 3px; scrollbar-face-color: #dcdcdc; scrollbar-highlight-color: #dcdcdc; scrollbar-shadow-color: #dcdcdc; scrollbar-3dlight-color: #dcdcdc; scrollbar-arrow-color: #999999; scrollbar-track-color: #dcdcdc; scrollbar-darkshadow-color: #dcdcdc; background-color: #dcdcdc; margin-left: 20px; overflow: scroll; padding: 10px;"><b><font color="purple" size="5" ptsize="10" FAMILY="FIXED" LANG="11">&#65290;&#65290;&#12288;</font><FONT SIZE=3 PTSIZE=10 FAMILY="FIXED" FACE="Times New Roman" LANG="11" color="#FF00FF">What's New</font><font color="purple" size="5" ptsize="10" FAMILY="FIXED" LANG="11">&#12288;&#65290;&#65290;<br> </font></b><font color="#000000" size="2" ptsize="10" FAMILY="FIXED" LANG="11"><br> </font> <font face="Times New Roman" color="#000000" size="5" ptsize="10" FAMILY="FIXED" LANG="11"> Starting in 2007, most of the United States and Canada observe <a href="http://en.wikipedia.org/wiki/Daylight_saving_time" target="_blank">DST</a> from the second Sunday in March to the first Sunday in November, shifting clocks typically at 02:00 local time. The 2007 U.S. change was part of <a href="http://en.wikipedia.org/wiki/Uniform_Time_Act" target="_blank">the Energy Policy Act of 2005</a>; previously, from 1987 through 2006, the start and end dates were the first Sunday in April and the last Sunday in October, and Congress retains the right to go back to the previous dates once an energy-consumption study is done. <br> <font color="#FF9966"><br></font></P></font></td><th width="2%" scope="col">&nbsp;</th></tr></table></td></tr></table> <br> <br> <p align="center"> <font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><a href="http://excelfan.com/070129WorldClockChina.xls" target="_blank"><img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="35" height"32"></a>&nbsp;&nbsp;&nbsp;&nbsp;World Clock for Beijing China </font><br> <span style="BACKGROUND-COLOR: #ffffff"><b><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED"><br> </font></b></span><font face="Times New Roman" lang="11" size="5" ptsize="10" family="FIXED">- January 30, 2007 -</font> </p><br> <p align="center"> <font face="Times New Roman" size="5" ptsize="10" family="FIXED" lang="11"> <a href="http://excelfan.com/070125WorldClockSummerTime.xls" target="_blank"><img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="35" height"32"></a>&nbsp;&nbsp;&nbsp;&nbsp; World Clock with Summertime<br> - January 25, 2007 -</font></p><br> <br> <p align="center"> <font face="Times New Roman" size="5" ptsize="10" family="FIXED" lang="11"> <a href="http://excelfan.com/060121ReviewClockEurope0003.xls" target="_blank"><img src="http://kenmzoka0.tripod.com/031113excelicon.png" border="0" width="35" height"32"></a>&nbsp;&nbsp;&nbsp;&nbsp; World Clock for Rome, Paris and Berlin<br> - January 26, 2007 -</font></p><br> <br> <p align="center"> Each of the following local version files now has<br> an <a href="http://kenmzoka.com/20000605internationaldialingcode.htm">international dialing code</a> sheet, which would help make international calls at the right timing, more efficiently.&nbsp; Dec. 6, 2000</font> </p> <p align="center"> <font face="Times New Roman" color="#000000" size="5" ptsize="10">Access&nbsp; <a href="http://kenmzoka.com/20000226WorldClockUK.xls"> World Clock UK</a>.&nbsp; The local times in </font> <font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11"> New York</font> </font><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11"> (the same as Ohio or Toronto)</font> </font></font><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11"> Los Angeles and Tokyo (the same as Korea) are shown relative to the time in the UK (GMT).</font><p align="center"><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11">World Clock UK is now designed to show correct times of Japan and the USA when summer time starts in the UK.&nbsp; It is a challenge to show the difference between the UK and US times for different dates summer time starts in both countries (Sunday, March 31 in the UK and Sunday, April 7 in the USA, in 2002).<br> Will this work?&nbsp; Let's find out on March 31 and April 7, both Sunday.<br> Here is the <a href="http://kenmzoka.com/20020124WorldClockUKSummerTime.xls">file</a>.<br> - January 24, 2002 -<br> It <i><b>did</b></i> work, and I am now sure it will for the years to come.<br> - April 7, 2002 -<br> </font><p align="center"><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11">World Clock for Japan is designed to show correct times of<br> the UK and the US during their summer times to the hours and the minutes.<br> I have yet to make sure this works throughout the year.<br> Here is the <a href="http://kenmzoka.com/020424JapanClockTrial.xls">file</a>.<br> - April 28, 2002 -&nbsp;&nbsp;</font><br> <br><br><br><br> <p align="center"> <font face="Times New Roman" color="#000000" size="5" ptsize="10"><br> Here are other area versions that were finished as of Mar. 3, 2000.</font> <p align="center"><font face="Times New Roman" color="#000000" size="5" ptsize="10"> <a href="http://kenmzoka.com/20000227WorldClockJapan.xls">Japan</a>; <a href="http://kenmzoka.com/20000227WorldClockOhio.xls"> Ohio (EST)</a>; <a href="http://kenmzoka.com/20000228WorldClockLA.xls"> Los Angeles</a> </font><u><font face="Times New Roman" color="#0000EE" size="5" ptsize="10"> </font></u></font><a href="http://kenmzoka.com/20000228WorldClockLA.xls"><font face="Times New Roman" size="5" ptsize="10" family="FIXED" lang="11" color="#0000EE"> (PST)</font></a><FONT SIZE=3 PTSIZE=10 FAMILY="FIXED" FACE="Times New Roman" LANG="11"><font face="Times New Roman" color="#000000" size="5" ptsize="10">; and <a href="http://kenmzoka.com/20000303WorldClockEurope.xls">Europe (GMT+1) </a> </font></font><p align="center"><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11">EST and PST are called ESD and PSD, respectively, (D for daylight saving)&nbsp;<br> for summer time.</font><p align="center"><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11"><a href="http://kenmzoka.com/20000215OhioWorldTime.xls">Blank Monthly Calendar and EST(D) Clock with World Time</a><br> - Sept. 30, 2001 -</font><br> <p align="center"> <br> <a href="http://www.oanda.com/convert/classic"> Currency Converter</a> by <a href="http://www.oanda.com">OANDA.com, The Currency Site<br> <br> <br> </a><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11">On</font><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11"> January 1st, 2002, 300 million Europeans in 12 countries woke up to a new<br> currency: the euro (EUR).&nbsp; The countries sharing the euro: Austria, Belgium, Finland,<br> France, Germany, Greece, Ireland, Italy, Luxembourg, the Netherlands, Portugal and<br> Spain.&nbsp;</font><p align="center"><font face="Times New Roman" color="#000000" size="5" ptsize="10" family="FIXED" lang="11">By courtesy of&nbsp; <a href="http://www.euro.ecb.int">www.euro.ecb.int</a> , &nbsp;<a href="http://excelfan.com/020410EuroConverter.xls">Excel Euro12-CurrencyConverter</a> lists<br> conversion rate of the 12 currencies to Euro and enables conversion both ways<br> between Euro and each of the 12 currencies.<br> - April 11, 2002 -<br> <br> </font><p align="center"> <center> <br> <span style="background-color: #800080"> <font face="Times New Roman" size="5" ptsize="10" color="#FFFFFF">Please visit my other sites:</font></span><FONT COLOR="#000000" SIZE=4 PTSIZE=10> <p align="center"><font ptsize="12" size="3" color="#000000"><a href="http://kenmzoka.tripod.com/">Excel Monthly Calendar</a></font> </p> </font> <p align="center"> <A href="http://www.bizland.com/join/index.html?masters=193&amp;promos=&amp;AffID=82421&amp; LinkName=ECWC"><BR><IMG SRC="http://affbanners.bizland.com/GetAffBanner.mpl?bid=25"></A><FONT class=norm><BR><br> </FONT></p> <p align="center"> <center> <a href="http://www.bravenet.com/" target="_top"> <img src="http://images.bravenet.com/pub/bravepride.gif" <a href="http://www.bravenet.com/" target="_top" width="102" height="52"> </a> </center></P> </center> </td><td><br><br><br><br><br><br><script type="text/javascript"><!-- google_ad_client = "pub-8248528368163939"; google_ad_width = 120; google_ad_height = 600; google_ad_format = "120x600_as"; google_ad_type = "text_image"; google_ad_channel =""; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><br><br> <br><br><br><br><br> </td></tr></table> <center> <FONT SIZE=3 PTSIZE=10 FAMILY="FIXED" FACE="Times New Roman" LANG="11"> <hr> </font> <div align="center"> <script language="JavaScript"> <!-- document.write("Last update: ",document.lastModified) //--> </script> <FONT SIZE=3 PTSIZE=10 FAMILY="FIXED" FACE="Times New Roman" LANG="11"> <div>Copyright (C) Ken Matsuoka</div></div> </center> <script src="//sharebutton.net/plugin/sharebutton.horizontal.js"></script> </BODY>