Search results

I tried by creating a new simple DB and importing your module in it. And then tried the fnComputeTime function. Please See the Screenshot When this function is applied, it returns the perfect output with the current (Time In & Time Out) values once. Then when I am changing TimeIn and TimeOut...

Yes BTID is unique. It can not be duplicated.

I am copying the module from the demo DB from this post.

When I am using this module in my DB: See how I am using this in my query: I did not make any changes to the module.

Mr. Arnel, Thank you very much! Each and every calculation is working perfectly in your demo file. I am just going to use this module in my database. Kindly tell me one thing that I have ID field with the name "BTID" instead of "ID" should I modify this module in my database?

Thank you very much for your help.

Hi, arnelgp its not calculating everything fine. Please check the screenshot attached. Let me tell you the criteria again: All late arrivals after 15 minutes of grace Time and early departure (any time before 6 PM) will be deducted from DutyHours. If someone arrives at 9:15 and leaves at...

It doesn't matter which way I go. I want it to be done. I'm not an expert, that's why I'm bothering you guys by asking questions again and again. Please guide me to what will be better for me. Actually, I am doing this part-time so sometimes I reply late.

Its not working please guide me.

arnelgp Can you please guide me on what's wrong here? Why DutyTime is -1074568? I've changed the code in module as you told: Applied fnComputeTime function in my Query:

yes But we need 9 hours in total when Time-In is 9:00 AM and Time-Out is 6:00 PM

I have applied the module now.

Thank you, dear, It’s overall working fine but I want 9:00 AM to 6:00 PM = 9 hours instead of 8 hours. After 6 Am on night regular hours and overtime hours are converting to negative value while I want 16 hours as overtime till 8:00 AM on the night. Can I use this in my own query? I am...

I am using the following code for DutyHours: DutyHours: iif(datediff("n",[Time_In],#2022-08-20 18:00#)<525,datediff("n",[Time_In],#2022-08-20 18:00#),540,iif(datediff("n",[Time_In],#2022-08-20 18:00#)<525,datediff("n",[Time_In],#2022-08-20 18:00#),540,iif(datediff("n",[Time_In],#2022-08-20...

Thank you arnelgp

Thank you so much let me try it.

I am really sorry to bother you again I am confused on some points. Can you please tell me: 1) arrived early ?iif(datediff("n",#Time_In#,#2022-08-20 18:00#)<525,datediff("n",#Time_In#,#2022-08-20 18:00#),540) 540 Is the above code correct? 2) I am using a query to calculate duty and OT hours...

Thank you so much, Can you guide me on where should I use these codes? is it for expression builder? Where are the Time-In and Time-Out in these codes?

If someone arrives at 9:16 AM 16 minutes will be deducted not 1 minute.

If someone arrives before 9:00 will be treated the same as 9:00 because there is no Overtime for early arrivals. So if someone arrives at 8:45 and leaves at 5:00? 1 Hour will be deducted from his/her duty hours.