Time Conversions

  • Thread starter Thread starter JDM Webmaster
  • Start date Start date
J

JDM Webmaster

I have a NetShow log that I have imported into Excel, I need to change the
date from Greenwich Mean Time to Central Standard Time (-6 hours). I have
tried everyway I can think of to get Excel to do this conversion for me but
I can not seem to make it work. Does anybody have any ideas?

Thanks
 
Easiest would probably be to use a help column and a formula like

=MOD(A1-0.25,1)

where A1 is the first imported time, copy down as long as needed and copy
and paste special
as values.

If all times are later than 6 in the morning you can just put 0.25 in an
empty cell, copy it, select the import,
do edit>paste special and select subtract, then format the range as time
again since it will be decimals..

6 excel hours = 6/24 = 0.25
 
=MAX(H17-TIME(6,0,0), 1+H17-TIME(6,0,0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top