View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robertn5itn robertn5itn is offline
external usenet poster
 
Posts: 2
Default 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