Mapping times from GMT to UTC
 

I am an amateur radio operator who travels all over. I am looking for a way
to simply add hours in a spreadsheet from GMT to
UTC.
Example.
28-Jul-07 18:38:05 0:10:54 355 11 314 256 18:48:59

The 18:38:05 represents time in GMT. I need to creat a formula that will
simply add say 7 hour to the 18:38:05 which will provide the UTC time. IE.
18:38:05 = 01:38:05.
I have attempted to use examples however they do not appear to work. Any
ideas?

Robert

Mapping times from GMT to UTC
 

XL stores times as fractional days (e.g., 3 hours = 3/24 = 0.0125).

So to add 7 hours

B1: 18:38:05

J1: =B1 + 7/24

Format J1 as a time

In article ,
robertn5itn wrote:

I am an amateur radio operator who travels all over. I am looking for a way
to simply add hours in a spreadsheet from GMT to
UTC.
Example.
28-Jul-07 18:38:05 0:10:54 355 11 314 256 18:48:59

The 18:38:05 represents time in GMT. I need to creat a formula that will
simply add say 7 hour to the 18:38:05 which will provide the UTC time. IE.
18:38:05 = 01:38:05.
I have attempted to use examples however they do not appear to work. Any
ideas?

Robert

Mapping times from GMT to UTC
 

I am an amateur radio operator who travels all over. I am looking for a way
to simply add hours in a spreadsheet from GMT to
UTC.
Example.
28-Jul-07 18:38:05 0:10:54 355 11 314 256 18:48:59

The 18:38:05 represents time in GMT. I need to creat a formula that will
simply add say 7 hour to the 18:38:05 which will provide the UTC time. IE.
18:38:05 = 01:38:05.
I have attempted to use examples however they do not appear to work. Any
ideas?

Is the text from your example all in one cell? If so, try this (which will
correct the date when the added amount takes the time past midnight)...

=TEXT(--LEFT(A1,18)+B1/24,"dd-mmm-yy hh:mm:ss")&MID(A1,19,99)

The above assumes your example text is in A1 and the amount of hours you
want to add is in B1

Rick

Mapping times from GMT to UTC
 

Thank you for the quick response. I works just as I hped it would.
--
Robert


"JE McGimpsey" wrote:

XL stores times as fractional days (e.g., 3 hours = 3/24 = 0.0125).

So to add 7 hours

B1: 18:38:05

J1: =B1 + 7/24

Format J1 as a time

In article ,
robertn5itn wrote:

I am an amateur radio operator who travels all over. I am looking for a way
to simply add hours in a spreadsheet from GMT to
UTC.
Example.
28-Jul-07 18:38:05 0:10:54 355 11 314 256 18:48:59

The 18:38:05 represents time in GMT. I need to creat a formula that will
simply add say 7 hour to the 18:38:05 which will provide the UTC time. IE.
18:38:05 = 01:38:05.
I have attempted to use examples however they do not appear to work. Any
ideas?

Robert

Mapping times from GMT to UTC
 

Sat, 28 Jul 2007 22:14:01 -0700 from robertn5itn
:
I am an amateur radio operator who travels all over. I am looking
for a way to simply add hours in a spreadsheet from GMT to UTC.
Example.
28-Jul-07 18:38:05 0:10:54 355 11 314 256 18:48:59

The 18:38:05 represents time in GMT. I need to creat a formula that will
simply add say 7 hour to the 18:38:05 which will provide the UTC time.

I don't see how that can be right. UTC is the same as London winter
time. By GMT you mean either the old name of UTC, in which case GMT =
UTC, or you mean the local London time, which is always either UTC or
UTC+0100.

Can you say some more about what you're trying to accomplish?

--
"The Internet is famously powered by the twin engines of
bitterness and contempt." -- Nathan Rabin, /The Onion/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/