Hello Chandoo
Apologies for the confusion. can we able to produce a report that shows break timings of an employee with their total working hours including breaks on daily basis. you given me a excel last time in that report I am able to export the daily break timings but not able to get the...
Hi Chandoo
Answering your questions.
Yes, this is the final version I needed.
We are expecting each employees should be meet 8.15 hours after all breaks. sometimes employees will log in early to finish their works, so the total working hours will different.
Some times employee forgot to...
My manager need a detailed report that's why I raised this again. in the previous report is excellent but we are unable to get the total working hours and break separately on date basis, it will only get the total hours deducting by breaks and breaks hours separately. also if anyone is logged...
Hello Chandoo
I need your help to set up a break time calculation template. we have an access report which is provided by the Facility Team, with in this report each entry and exit of an employee is recorded as per the swipes into swipe machine. in the format of this report is too difficult and...
Hi Sorry to bother you again. i need one more help with this macro file. in this file you added the weekly hours for working and break. is it possible that we can show total working hour along with it. by first log in and last log out for the day so when we run a macro the result give the total...
Hello Can you please help me with one question. I need one more feature is added to be this macro file. i have to show the Total Working hours along with the break time. that would be calculated from the first log in and last log out. then only i can analyze the exact break timings. we have...
Hmm Okay, Narayan. i try to add solver add in to find out a solution but for this i have to take a lot of approvals. is there any way that we can use some macro, is this possible
Hello Narayan
Sorry for the confusion. You gave me one resolved file for clearing. i also want to fix this as template for my GL clearings. is this possible that we could set up a template. also i want to make sure that if the assignments have 50 lines and only 6 lines able to clear from the GL...
Hi Narayan
Thanks for the prompt action. Yes this is what I am expected I can see that few assignments only you have marked but I wanted to check if there is any other assignments having items to clear for example one assignment have twenty line and 5 lines will able to clear that item too...
Dear All
I have suspense GL and responsible to clear the GL accurately. at the moment i have to spend a lot of time to finish this. So i am expecting your support to reduce the efforts. i have to clear the balance with in the assignments. I have attached a file and i have to highlight the...
Yes, but what I am confused here is the total break time for Dinil 2.20 is only for one day not entire day. in your file each breaks are showing under different dates. correct me if I am wrong.
Hello
I have calculated manually the break time for Antony Dinil and I am getting 2.20.57 on 16th March. here is the way I calculated the break time. I consider the exit and entry marked in red.
09:17:00 PMKOCHI CARNIVAL 1F INVISTA EXITAccess Granted30115822104387ANTONY, DINIL
07:1:06 PMKOCHI...
Hello
Thanks for the detailed explanation, for a safe example after running the macro the user Antony Dinil got break time 3 minutes on 16th March 2018, I calculated it manually and the actual break time is around 1 hour. this is what my concern with it.
Hi Narayn
Yes, I saw that one but I am not sure all exit and entry calculated apart from first log in and last log out. bcz I noticed that few of my staff are only take 25 minutes as per the report that's wrong. that's what I confused.
Hi Narayan
Yes this for all date, if one person have single log in and log out you can exclude them bcz they are security or other staff not the employees reporting to me. from this report I will sort out the persons who reporting to me.
Regards,
Dinu Kunjunju
Hello Narayan
A Safe example is Please select Card holder as T K, Dinu and select date 12th of March you can see the first time is 11.0.10 Am actually this was he entered in office first time that day. so this should be excluded from break time calculation. then 8.26.54 PM he is left from...
Hello Narayan
Thanks for the update. its really help full. I would check one thing with you as I need to exclude the first entry and last exit from a date for a particular date and the rest of the entry exit will calculate the break time. I am seeing few persons are taking 2 more hours I think...