convert UTC to MST

[Terry Carpenter]

Hello!
I have a column with date/time formatted cells like: 04/21/03
15:12
The time part is UTC. In the next column I would like to show the same
info but with the time portion converted to MST. I have tried to use
the TIME worksheet function but how can I get just the time out of the
cell?

Thanks!

[Jimmy L. Day]

=HOUR(A2)-6&":"&MINUTE(A2)
where =NOW() is in A2

From this you can deduce the date parts if you need them.

--
Greeting from the Mississippi Gulf Coast!
http://myweb.cableone.net/twodays
"Terry Carpenter" <terry.c...@lmco.com> wrote in message
news:6c278vkphgd5n8sna...@4ax.com...

[Terry Carpenter]

Please disregard, I can just add/subtract whatever difference since
the cell is a date.

[Stephen Smallman]

Terry,
Excel stores Dates and Times as numbers (depending on your set up, day 1 is
probably 1/1/1900, and 1/1/2000 is 36526)

Dates are stored as whole numbers, and times as fractions of a day, so 08:00
on 1/1/2000 is 36526.33333 etc
Therefore, to convert to MST (whatever that is) add/subtract your time
differential from Zulu. Here on East Coast Australia, in Daylight Savings
Time (summer time or whatever) we are UTC +11, therefore to convert to
local, I would add 11/24 to the time (eg value in A1 in B1
formula"=A1+11/24")

To display only the time portion, format the cells as time.

Steve

"Terry Carpenter" <terry.c...@lmco.com> wrote in message
news:6c278vkphgd5n8sna...@4ax.com...

[David McRitchie]

Hi Terry,
Glad you did not ask for Daylight Savings Time.
Simply subtract 7 hours from you UTC to get
US Mountain Standard Time.

B3: 04/21/2003 15:12
C3: =B3 - 7/24

More information on Date and Time in
http://www.mvps.org/dmcritchie/excel/datetime.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Terry Carpenter" <terry.c...@lmco.com> wrote in message news:6c278vkphgd5n8sna...@4ax.com...