Convert time from GMT to local time?

AzMike · May 19th, 2002, 06:17 PM

I have a sheet that contains time stamped events. The time stamps are in GMT (UTC), is there an wasy way to ~accurately~ convert these to local time?

Anne Troy · May 19th, 2002, 06:52 PM

Well. I am -5 GMT.

5 / 24 (hours) = .20833333333

If I subtract .20833333 from the GMT time, I get my time.

Cells must be formatted to show time and date.

Ivan F Moala · May 19th, 2002, 07:13 PM

Quote:

On 2002-05-19 17:17, AzMike wrote:
I have a sheet that contains time stamped events. The time stamps are in GMT (UTC), is there an wasy way to ~accurately~ convert these to local time?

I have a workbook that calculates this.
If you want I can email you.

May 19th, 2002, 06:52 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Well. I am -5 GMT. 5 / 24 (hours) = .20833333333 If I subtract .20833333 from the GMT time, I get my time. Cells must be formatted to show time and date. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 19th, 2002, 06:17 PM	#1
AzMike New Member Join Date: May 2002 Posts: 1	I have a sheet that contains time stamped events. The time stamps are in GMT (UTC), is there an wasy way to ~accurately~ convert these to local time?