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