Log Timestamp Format

From Swivel Knowledgebase Wiki

Contents 1 Overview 2 Prerequisites 3 Symptoms 4 Solution

Overview

The PINsafe log Timestamp provides the date and time of an event, this can be converted into an easy to read format

Prerequisites

What is required to resolve the issue, versions etc

Symptoms

PINsafe Log Timestamp is not easily readable

Solution

Use the following forumla in Excel and format the cell to as a date or time or a custom value of date and time:

=25569+value/86400000

Example for a timestamp of: 1266929100563

=25569+1266929100563/86400000

For the format dd/mm/yyyy hh:mm:ss This gives:

23/02/2010 12:45:01