Overclock.net › Forums › Software, Programming and Coding › Operating Systems › Windows › Need a keylogger for a scientific study
New Posts  All Forums:Forum Nav:

Need a keylogger for a scientific study - Page 2

post #11 of 13
Thread Starter 
Shamrock thank you so much this should work perfectly and yes any alternative to a keylogger would be preferable for sure!


One quick question though, I tried to write a few sentences and the time stamp all came out the same (1.46958e+12) under A, I see that the actual number differs and increases with each character, how do I convert that number it to hours:minutes:seconds:milliseconds?

Thanks again this amazing!

Edit: Just realized you already explained it's in seconds, this will do for sure, I hope I'm not asking for too much but is there any quick way to then convert it perhaps on the document (I'm using excel) to h/m/s/milliseconds? If not no worries we'll make it work!
Edited by Jupitel - 7/15/16 at 4:26am
post #12 of 13
They are Unix Timestamps, it would be easiest for Shamrock to do it on his end smile.gif, so 1468585880 = Fri, 15 Jul 2016 12:31:20 GMT

Also awsome work Shamrock!
Escobar
(9 items)
 
Supercomputer ^_^
(13 items)
 
 
CPUMotherboardGraphicsRAM
1055T M4A88T-D EVO USB3 ATI 6850 4 GB 
Optical DriveOSMonitorKeyboard
DVD RW Windows 8 Pro lp1900 + 2 X 15 inch dell Microsoft Comfort Curve 
PowerCase
600watt thermaltake antec 200 
  hide details  
Reply
Escobar
(9 items)
 
Supercomputer ^_^
(13 items)
 
 
CPUMotherboardGraphicsRAM
1055T M4A88T-D EVO USB3 ATI 6850 4 GB 
Optical DriveOSMonitorKeyboard
DVD RW Windows 8 Pro lp1900 + 2 X 15 inch dell Microsoft Comfort Curve 
PowerCase
600watt thermaltake antec 200 
  hide details  
Reply
post #13 of 13
Since the value I record is the number of milliseconds since 1970 in the UTC timezone, its a very large number so you have to tell excel you don't want it in scientific notation.

To get a real date out of it, on another column, put in a formula

= (A2 / 86400000) + DATE(1970,1,1)

and then format the cell with this custom formater: hh:mm:ss.000 (Category: custom, then fill in type with this string)
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Windows
Overclock.net › Forums › Software, Programming and Coding › Operating Systems › Windows › Need a keylogger for a scientific study