• 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 Daily Attendance.

Lasantha

Member
Dear Team,


Could you please help me to create a Macro or working file to capture IN and OUT times, production times , break times and Incomplete entities from raw data.

Thank you very much for your time.

Lasantha.
 
Last edited by a moderator:
Here is one method :

Formulas :

G2 : =IF(F2="","",F2-E2)
H2 : =IF(G2="","",IF(G2<(8/24),"0.5","1"))
J2 : =IF(H2="","",(G2-I2))
K2 : =IF(E2&F2="","",IF(F2="","Incomplete",IF(E2="","Incomplete","")))
ALL FORMULAS DRAG DOWN THE COLUMN

Formatting and Entries :
#2 - Columns E, F, G, I, & J are formatted as CUSTOM / [h]:mm:ss
#3 - Columns E & F must be entered as : M/D/YYYY H:MM or MM/DD/YYYY H:MM depending on the date.
#4 - Partial Hours are entered as: 0:15 for fifteen minutes, 0:30 for thirty minutes, 0:45 for 45 minutes.
#5 - If either E or F are left blank, INCOMPLETE displayed in Column K and highlighted in RED.


Concerning transferring the RAW data to the IS BLANK worksheet ... hopefully someone else can provide that answer for you.
 

Attachments

  • Is Blank.xlsx
    12.9 KB · Views: 24
Back
Top