Enroll Now
Best Seller Icon Bestseller
0 rating
4 students

DIPLOMA IN TIME KEEPER

  • Last updated Nov, 2025
  • Certified Course
₹6,000 ₹6,500
Enquire Now
  • Duration6 Months
  • Enrolled4
  • Lectures120
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

1. Introduction to Excel for Time Keeping

  • Workbook & worksheet basics
  • Rows, columns, cells
  • Basic navigation & data entry

2. Employee Attendance Data Entry

  • Entering employee codes & names
  • Marking Present/Absent/Leave
  • Using dropdown for attendance status
  • Using date formats correctly

3. Formatting for Attendance Sheets

  • Cell formatting (text, number, date)
  • Conditional formatting (late mark, absent highlight)
  • Table formatting for employee lists

4. Time & Shift Management in Excel

  • Entering in-time and out-time
  • 12-hour vs 24-hour time format
  • Shift allocation (A, B, C, Night shifts)
  • Calculating working hours

5. Important Time-Related Formulas

  • SUM (total hours)
  • COUNT, COUNTA (counting days)
  • IF (late/early logic)
  • Nested IF for shift rules
  • TIME, HOUR, MINUTE functions

6. Overtime & Extra Hours Calculation

  • OT calculation formula
  • Double OT, holiday OT
  • Weekly & monthly OT summary
  • Auto OT calculator using formulas

7. Leave & Weekly Off Management

  • Leave register in Excel
  • Paid/Unpaid leave calculation
  • Weekly off auto mark system
  • Monthly leave summary sheet

8. Monthly Attendance Register

  • Complete attendance calendar
  • Employee-wise monthly sheet
  • Auto present/absent count
  • Late coming & early going report

9. Payroll Support Sheets

  • Wage calculation based on hours
  • Overtime amount calculation
  • Summary sheet for HR/Accounts
  • Exporting data for payroll software

10. Reports, Charts & Printing

  • Attendance summary report
  • OT comparison chart
  • Shift distribution chart
  • Page setup for printing
  • Headers/footers (Company name, month)


Show More

Course Syllabus

1. Introduction to Excel for Time Keeping

2. Employee Attendance Data Entry

3. Formatting for Attendance Sheets

4. Time & Shift Management in Excel

5. Important Time-Related Formulas

6. Overtime & Extra Hours Calculation

7. Leave & Weekly Off Management

8. Monthly Attendance Register

9. Payroll Support Sheets

10. Reports, Charts & Printing

Course Fees

Course Fees
:
₹6500/-
Discounted Fees
:
₹ 6000/-
Course Duration
:
6 Months

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%

Featured review

No reviews yet. Be the first to review this course!

Top Course

More Popular Courses

View All Course
-8% Off
(0 Reviews)

DIPLOMA IN ADVANCE EXCEL

  • 8 Students
In DIPLOMA COURSES
₹6,000 ₹6,500
Learn More
-7% Off
(0 Reviews)

DIPLOMA IN TALLY PRIME WITH GST

  • 2 Students
In DIPLOMA COURSES
₹8,000 ₹8,600
Learn More
More Similar Courses

Related Courses

-8% Off
(0 Reviews)

DIPLOMA IN ADVANCE EXCEL

  • 8 Students
In DIPLOMA COURSES
₹6,000 ₹6,500
Learn More
-7% Off
(0 Reviews)

DIPLOMA IN TALLY PRIME WITH GST

  • 2 Students
In DIPLOMA COURSES
₹8,000 ₹8,600
Learn More
-8% Off
(0 Reviews)

DIPLOMA IN STORE KEEPER

  • 4 Students
In DIPLOMA COURSES
₹6,000 ₹6,500
Learn More

Copyright © 2025 DITRP INDIA. All Rights Reserved