Mapping times from GMT to UTC

[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. IE.
18:38:05 = 01:38:05.
I have attempted to use examples however they do not appear to work. Any
ideas?

Robert

 

[JE McGimpsey]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[robertn5itn]

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

 

[Stan Brown]

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?