Hey guys,

It does point me in the right direction...

Sorry for the delay in responding. I had to convert yesterday and it had me
unable to access my MS products..
I'll test it today.

The issue of DST may turn out to be an important one, since the logs will
need to be reconsiled with server data and the less variance, naturally, the
better..


Thanks,
DR

"Ron Rosenfeld" wrote:

On Wed, 30 Jul 2008 18:20:00 -0700, DR wrote:

Hey Ron,

This is the macros I'm working with.
I'd like to have it such that the local time zone is either gotten from a
user selected cell, or by a get_time_zone function..

Any clue??
Anyone?
Beuller?


Sub InsertTime()
'
' InsertTime Macro
' Inserts the current time in the selected cell.
'
' Keyboard Shortcut: Ctrl+z
'
ActiveCell.FormulaR1C1 = "=NOW()"
ActiveCell.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveCell.Offset(0, 1).Range("A1").Select
End Sub


Does Rick's solution point you in the right direction?
--ron