How to track break time in office automatically in Excel

[@SD-bq5uk]

How do u get all data accurate..show in detail how to build this dashboard bcz there are many formulae used in all column I guess..tis video is only show the general info..kindly make a video or share a link which can say indetail in building tis dashboard

[@SessionsbySaurabh]

Thanks for the feedback. I have used VBA to build the application. No formula is used in the columns.

[@altaftraining7645]

What if the Employee go for a break and do not start timer? Is there any way to avoid this situation ?

[@SessionsbySaurabh]

We can’t avoid this situation but we can handle the situation where timer will start automatically.

[@altaftraining7645]

@@SessionsbySaurabh Can you please help how.. like if the system is locked the timer should start automatically. Also I am noticing that tracker is recording login time on Monday Line item when it is Tuesday today.

[@JeromeAnusencion-b6j]

The file is no longer working. No formula also

[@SessionsbySaurabh]

Hi, thanks for highlighting. I have modified the sheet and updated the link in the description. Please download the sheet and check. Also, suggest in comments section if further improvements can be made.

[@jeromeanusencion342]

@@SessionsbySaurabh Can you share link here with no password.

[@SessionsbySaurabh]

Hi, you can use below passwords to unprotect the sheet or VBA to Unprotect the Sheet: Exc3lSess!0ns VBA project password: Exc3!S3ss!0ns Logs sheet password: L0gsp#d

[@SessionsbySaurabh]

drive.google.com/file/d/1Xj4dcY4uD51xCEUJWSPqh4xL8eQ41pNB/view?usp=sharing

[@nickpanchal3536]

Can you please share the password of this sheet?? Because it is password protected. It will be very useful for me.

[@SessionsbySaurabh]

You can use this sheet without password. Is there any functionality you are unable to use ?

[@nickpanchal3536]

@@SessionsbySaurabh The problem is today is Tuesday and it's enter a data in Monday column automatically. I don't understand the problem. Also, we work for USA client so in every PC region is English(United State).

[@SessionsbySaurabh]

@@nickpanchal3536 Hi Nick, please send an email on [e-mail]. I will share the related information.

[@nickpanchal3536]

@@SessionsbySaurabh I have sent you an email. Can you please help me with it.

[@SessionsbySaurabh]

Check this sheet (without password) drive.google.com/file/d/1rs2oU2yOIYbIFwipsipak24mGbDaR7J6/view?usp=sharing

[@sadiqams9070]

Hi it's asking for password

[@SessionsbySaurabh]

check this sheet (without password) drive.google.com/file/d/1rs2oU2yOIYbIFwipsipak24mGbDaR7J6/view?usp=sharing

[@snehalkotnake3295]

It's not working

[@SessionsbySaurabh]

Hi Snehal, what problem are you facing??