Track system Time

[Nipendra.dhiman]

Hi experts,
Sorry if this sounds looks dumb
Is it possible to track system time by vba code in Excel while system is active.

I need to know,

if I want to build an application in excel vba on the below requirement-:

1)-whenever i'll login vba code should take as start time
2)- when I'll take break and lock system for a while it should be come as break time(until system locked).
3)-user should not need to open any tool or excel file to track this operation it should be automatically on user login.

please share the suggestion if possible.

Thanks In Advanced
Regards
Nipendra

 

[Luke M]

I don't think this is possible with XL. No way to track system actions.

 

[Abhijeet R. Joshi]

To have the timings you can use the below in the VBA Code, however I am not sure if we can capture the locking/unlocking of the systems..

Range("A1").value=format(now(),"HH:MM:SS")