Time Zone Conversions
hi Jeff,
Am Fri, 25 Jul 2014 14:16:43 +0100 schrieb Jeff Kohl:
I have figured out a formula and then formatted the cells appropriately
to get them the way I need them to look. I couldn't upload the document
but attached are two screenshots of the values and the corresponding
formulas.
in A1 try:
=B1-TIME(VLOOKUP(C1,{"HKT",13;"EDT",1;"GMT",5},2,0),,)
Possibly you have to modify the separators
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|