Use this forum to post questions relating to WinGate, feature requests, technical or configuration problems
Apr 12 04 10:36 pm
How convert the format of starttime in the HISTORY to dd/mm/yy in excel , thanks?
Apr 16 04 7:05 pm
=(x/86400)+25569
In that formula, x, represents the date/time. 86400 is the number of seconds per day, the 25569 is the base for 1 January, 1970.
If you then set the format of that cell to be a date field, with the appropriate time formatting, it should appear correctly.
Apr 16 04 7:25 pm
ok, but i would know too the time in another colum???, how?
Apr 16 04 7:42 pm
Nope, that gives you date and time
Powered by phpBB © phpBB Group.
phpBB Mobile / SEO by Artodia.