Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mapping to QuickBooks Pro | Excel Discussion (Misc queries) | |||
mapping two worksheets | Excel Worksheet Functions | |||
mapping | Excel Worksheet Functions | |||
mapping add-ins | Excel Discussion (Misc queries) | |||
mapping add-ins | Charts and Charting in Excel |