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