calculate cumulative late (1 Viewer)

hatmak

Registered User.
Local time
Yesterday, 23:19
Joined
Jan 17, 2015
Messages
121
Hatmak is Mr.:):)

after I changed time for morning for employee 08:00 ( start time ) and 15:30 ( end time ) in data DATA_QRY


percenatge deducated Not changed still 10 % and other

attached file after change time in and out
 

Attachments

  • Files_1.zip
    183.3 KB · Views: 129

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:19
Joined
May 7, 2009
Messages
19,169
test it again mr.
I saw your post on the other side of the world.
only chit chat, no action.
 

Attachments

  • Files.zip
    126 KB · Views: 127

hatmak

Registered User.
Local time
Yesterday, 23:19
Joined
Jan 17, 2015
Messages
121
I posted my post in all the world to any advise

but no one response

really you patient and Creator

thanks you a lots for your response:)

please check attached file
is 66 min delay but percentage still 10 %
 

Attachments

  • 11.png
    11.png
    43.5 KB · Views: 116

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:19
Joined
May 7, 2009
Messages
19,169
mr. hatmak, one more test see what is wrong.
 

Attachments

  • Files.zip
    138.3 KB · Views: 128

hatmak

Registered User.
Local time
Yesterday, 23:19
Joined
Jan 17, 2015
Messages
121
thank you Mr. Arnelgp

some trouble last days made me can't open internet

I will test and tell you

thanks
 
Last edited:

hatmak

Registered User.
Local time
Yesterday, 23:19
Joined
Jan 17, 2015
Messages
121
Thanks so much! Arnelgp

a big thanks to you

awesome work


regards
 

hatmak

Registered User.
Local time
Yesterday, 23:19
Joined
Jan 17, 2015
Messages
121
Mr. Arnelgp

please check


CummulativeLate (min): Val(Nz(fnCummulativeLate([id],[uotono]),0))


cummulativeealy(min): Val(Nz(fnCummulativeealy([id],[uotono]),0))


is not working correctly


sorry again
 

Attachments

  • Test_Time_new.zip
    75.7 KB · Views: 123

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:19
Joined
May 7, 2009
Messages
19,169
I can't see any trouble.
I changed it a bit, so you can enter new months.
 

Attachments

  • Test_Time_new.zip
    79.9 KB · Views: 122

hatmak

Registered User.
Local time
Yesterday, 23:19
Joined
Jan 17, 2015
Messages
121
Mr. Arnelgp

Thank You For your Reply

ok I will check again

regards
 

Users who are viewing this thread

Top Bottom