About Us

Jeff Kohl

I would like to have a formula where I can input a date and time from one time zone (HKT, GMT, etc...) and have the conversion time be my local time (Central Time Zone). I've tried doing this but one problem I'm having is when I put Tuesday, July 29th @ 10:00 AM HKT and convert that to my local time, it would be Monday, July 28th @ 9:00 PM CDT.

I'm struggling building a formula that would recognize that the time would be 9 PM of the previous day. Does anyone have an answer for this?

I want to be able to plug in dates and times for HKT, GMT, EDT and have it convert to my local time.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with time conversions	WPP	Excel Worksheet Functions	5	February 6th 09 09:55 AM
decimal time conversions	Paul	Excel Discussion (Misc queries)	8	January 6th 09 06:25 PM
convert time from one zone to other zone in excel	ram	Excel Worksheet Functions	1	April 25th 07 01:24 PM
Time conversions	Holsapple	Excel Worksheet Functions	3	September 18th 06 09:06 PM
Date and Time conversions	Darin Kramer	Excel Programming	3	August 24th 05 11:27 AM

Menu

About Us