Mapping times from GMT to UTC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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?
Click to expand...

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
 
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.
Click to expand...

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?
 
Back
Top