i need to convert from UTC time to Local -7 hours offset

[Guest]

i need to convert data from UTC time to my local time witch is -7 hours from
UTC (GMT)

 

[Frank Kabel]

Hi
simply subtract (add) the appropiate time to your cells. Just nore that
1 hour in Excel is equivalent to 1/24

 

[Guest]

I tried that can you give me an example I need a formula that will subtract
-7 hour for a time colume

 

[JulieD]

Hi Kevin

=A1-7/24

Cheers
JulieD

I tried that can you give me an example I need a formula that will subtract
-7 hour for a time colume

 

[JulieD]

sorry that should be
=A1-7/24

the extra + is not needed

 

[Frank Kabel]

Hi
if A1 contains 12:00 enter the following in B1:
=A1-7/24

 

[Guest]

Hi thats a start now it is a decimal number. do I have to multiply this by a
seconds or miniuts conversion This is what I need as a final product below

the desired results would be
A1 A2
16:36:20 09:36:20 (this is the final number -7 hours from 16:36:20

 

[Frank Kabel]

Hi
just format this cell as Time

 

[Myrna Larson]

YOu don't have to do any conversion. Just change the format. You can do that
with the format painter by painting the format from the source cell.