Break Time calculation( in- out)

[vletm]

Dinu Kunjunju ... hmm?
Sentences 1 & 2 are okay.
The 3rd sentence isn't possible! ... because raw data has mistakes!
the 4th sentence as well ... that works only with ideal data!
9:30 working and 1:30 breaks ... okay!
... if any one is logging early ... that isn't possible, because no marks WHEN would be too early!
>> Now, there are separate work (entry-exit) and break (exit-entry) hours!
>> and if someone haven't use normal entry-exit sequence then that days break hours cell is yellow!

#8 Reply - You should mark Yourself MANUALLY mistakes!
which You have marked as 'hide' and
if You would like to 'forget' ALL of those, press [ReSet Hides].
'Hiding':
Highlight any row Device-cell by any 'Fill Color'.
After that row won't notice while NEXT [Calc Breaks].
That 'mark' will show by yellow 'Fill Color'-cell in results.

 

[Dinu Kunjunju]

Okay, Then is it possible we can calculate the total working hours by first log in and last log out. rest thing i will do manually.

 

[vletm]

Dinu Kunjunju
Did You even try to read my previous reply?
eg if there is ONLY 08:19 EXIT for ONE DAY then ... NO!
eg if ONE WEEKS breaks are OVER 60hrs then ... NO!
As I wrote twice, You should mark Yourself MANUALLY mistakes!

 

[Dinu Kunjunju]

Dinu Kunjunju
Did You even try to read my previous reply?
eg if there is ONLY 08:19 EXIT for ONE DAY then ... NO!
eg if ONE WEEKS breaks are OVER 60hrs then ... NO!
As I wrote twice, You should mark Yourself MANUALLY mistakes!

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 working hours and total break time, rest of the things i will put manual formulas. Pls help.....

 

[vletm]

Dinu Kunjunju
Try to ReRead my previous Reply #28
Especially the last sentence:
You should mark Yourself MANUALLY mistakes!