• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to capture IN , OUT and break time

Thank you sir,
This is perfect. Now no issue with date format.
Could you please add a button to clear data and run next data file.
I mean clear data in "data sheet" A to F column and summary sheet data.

Appreciate your help on this task.
Lasantha.
 
Wow this is awesome. :):):)

I like that Conditional Formatting.

I need a add a comment for missing IN and OUT employees as "IN COMPLETE" to column G

Ex, EMP 10001, missing IN time , can you please add a comment on G column as "IN COMPETE",

Thank you very much,
Lasantha.
 
Lasantha
"... This is perfect. Now no issue with date format. ..."
Have You really checked/compared [Data] and [Summary]-sheets?
There are ... something ... which do not 'look' good!
You should check/compare/verify at least if You'll use this somewhere!
You'll see some new features ... and You should see some of those 'something'.
>> Ideas ... Answers ... Questions?
 

Attachments

  • Data file.xlsb
    52.7 KB · Views: 3
Lasantha
#1) 'H'-column messages triggers 'Name's colors
#2) 'LIDs'-column should be empty! = shows IN-OUT-... OUT = (12...2)
if not empty (ex 12112)
then calculations could give wrong result >> 'Name' will be red too
>> #2 overrides always #1 << have to solve! >>
>> Ideas ... Answers ... Questions?
 

Attachments

  • Data file.xlsb
    73.6 KB · Views: 8
Lasantha - still thinking about this case ... hmm?
More I check ... more 'what is going on!' comes in my mind!
This is the 1st time then I have noticed that
one 'No.' can have two 'Names' and
one 'Name' can have two 'No.'s.
Those ... will make interesting combinations ... as You might notice.
Maybe there is some kind of system, but the 1st time always surprise me.
I also test one new layout:
It would be possible to use 'one month data'
and get the whole months results with or without some 'extras'!
And of course, one day's /name's 'INFO'-box.
Screen Shot 2017-05-30 at 18.36.25.png
>> Anyway, Do not use previous versions in real world! Too many mistakes! <<
 
Hi ,
Thank you.
Sorry for delay reply.
I was out of office .
I have checked and removed all duplicate Names ans IDs from the system.
I have to implement final version before this Friday. Can you please help me to finalize this. I have attached you new data file for further information. (no duplicate Name and IDs).
can you please send me above version. it looks more attractive and have more information.
I have checked your last macro which sent me last Thursday with this data file.
  • I have randomly QA some records, those are look OK.
  • I can't understand conditional format on column B,D, E F and G. Can you please explain this to me.
Please take attached data file.
Thank you very much for your time for this.
Lasantha.
 

Attachments

  • Data File 5_19_2017.xlsx
    23.3 KB · Views: 10
Lasantha - I have to implement final version before this Friday. :DD
And You just miss one week - So, good luck!
Hmm - conditional formatting? Previous version ...
B,D,E are not any conditional formatting!
B tries to tell if not 'full working day' or if there are some challenges -
compare to H-column.
D,E tries to show when and what kind of timestamps has done -
do someone knows when (what time) those 'Names' really work
... or have breaks
F,G ... oooo ... how to explain? ...
it shows amount of time by comparing to max break or working hours.
- some of those are not used any more with newer version!
As I wrote, the older version has many challenges = not good results!
Of course some are correct, but even one challenge is too much!
The newer version haven't tested, but it seems to be 'better'... but not ready!
> Ideas ... Answers ... Questions?
 
Hi , Thank you,
Yes badly miss 1 week, :(:rolleyes:
Thanks for the update.
Can you please test new version with my current data file(5/19/2017).

I am waiting....

Thank you very much for your time.
Lasantha.
 
Lasantha ... What are You waiting?
Did You open and check that file?
The 19th May data can find under day Fri19 and
as well as all possible previous datas too.
 
Lasantha
What do You mean?
You have that my so far the newest version there?
You can download those as many times as You ... want.
Normally, once is enough?
 
Lasantha
Yes ... No ...
just noticed that for some reason the last file didn't loaded ... hmm?
I gotta try one more time.
If not come ... just let me know ... okay?
 

Attachments

  • Data_file.xlsb
    101.4 KB · Views: 4
Hi ,
Thank you very much for this advanced version.
  • I have run this for 5/22 and 5/23, when I run this for 5/23 , 5/22 details automatically disappeared. Can you please do something for this.
  • Can you please add a button to clear data and run next data file.
  • Let me know how D2,D3 and D4 cells are working.
Thank you again for your time.
Lasantha.
 
Lasantha - focus - there is something 'new'.
#1) As I wrote in #31:
It would be possible to use 'one month data'
and get the whole months results with or without some 'extras'!

... means that You copy max ONE MONTH data
(= days from 1 to end of month) to data-sheet as there is now,
start from cell [B2]).
There is ONE MONTH calendar with summary column (the most right side)

#2) I added [ Clear Data ]-button to 'Data'-sheet.
#3) Activate any of those cells, if background color change from gray You will see more detailed information from data. 'work' = workingtimes, 'break'= breaktimes and 'miss'=something missing from data.
#4) As I wrote #33:

The newer version haven't tested, but it seems to be 'better'... but not ready!
... and it means that too!
> Ideas ... Answers ... Questions?
 

Attachments

  • Data_file.xlsb
    94.6 KB · Views: 13
Hi
Hope your doing well.
Thank you very much for your time.
I have only 1 week data. I have run new Macro with it. I have a question. Can you please look into this.
  • Employee Lasantha karunarathne's details missing for 5/26, but there is records for this individual for this date. Please check attached data file.
  • Employee Tharika Seram's details also missing for 5/26, IN time is available for this date , but OUT time is missing. this should mark as IN COMPLETE(MISSING DATA).
  • Employee Dilka Subhashini's data missing for 5/24,
Could you please review this again. I have attached above Macro file.

Thank you,
Lasantha.
 

Attachments

  • Data_file 06052017.xlsb
    128.3 KB · Views: 6
Hello Folks

need your support. i have a break time file but in a different format. can you help me to get some macro codes that i can use it to calculate the break timings.
 
Hi,, I'm looking to track my team's break IN/OUT time. Also during working time I would like to track the time they've took to complete one report. For example: while starting the report, they need to click start button and end button receptively when they complete it. Can we make this using macro using excel. Please help me creating this sheet.

Thank you
 
Hi, I need help as well. I tried copying + pasting another data to the "Data file", but encountering error as shown in image:
 

Attachments

  • 1563912411782.png
    1563912411782.png
    2.9 KB · Views: 1
Back
Top