Event-log.xlsx

Pau Lo

<div>
You can use <i>VBA </i>to create a function:<br />
<br />

<pre><code id="code-20-42861092-1">Seconds = 926060571 
TrueDate = DateAdd(&quot;s&quot;, Seconds, #1/1/1990#)

TrueDate -&gt; 2019-05-07 07:02:51 </code></pre>
</div>


You can use VBA to create a function:



Seconds = 926060571 
TrueDate = DateAdd("s", Seconds, #1/1/1990#)

TrueDate -> 2019-05-07 07:02:51 

<div>
<div class="content wysiwyg-content">
we have an old legacy erp system which stores audit event logs in a format of seconds since 01/01/1990. I am trying to find a way to covert the values into something more useful, e.g. a date &amp;&nbsp;time. &nbsp;e.g. 926060571 is one value, and is supposedly the number of seconds since 01/01/1990 to when that event occurred in the system, but I could do with some assistance on a formula to convert it to an actual date/time.
</div>
</div>


we have an old legacy erp system which stores audit event logs in a format of seconds since 01/01/1990. I am trying to find a way to covert the values into something more useful, e.g. a date & time.  e.g. 926060571 is one value, and is supposedly the number of seconds since 01/01/1990 to when that event occurred in the system, but I could do with some assistance on a formula to convert it to an actual date/time.

converting seconds since a date into date/time

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.