[mrtg] Re: converting mrtg timestamp in excel

[Sawyer, David]

X & Y will be the Cell within Excel where the data comes from,

IE
=(B6)/86400+DATE(1970,1,1)


DATE is an internal command so don't worry about it.

Just make sure you format the cell that has this sum to show either time &
date or just date.

HTH

Dave

-----Original Message-----
From: Tagle, Michael F. [mailto:michael at cureinc.com]
Sent: 18 March 2002 05:13


I'm trying to get the real date/time logged by MRTG. how can convert the
date/time using excel? reference says this is the formula:
"=(x+y)/86400+DATE(1970,1,1)
". but what about those variable like X,Y and DATE?


----------------------------------------------------------------------------
The information contained in this e-mail is confidential and is intended
only for the named recipient(s). If you are not the intended recipient you
must not copy, distribute, or take any action or reliance on it.
If you have received this e-mail in error, please notify the sender.
Any unauthorised disclosure of the information contained in this e-mail
is strictly prohibited.
----------------------------------------------------------------------------



--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi