+ Reply to Thread
Results 1 to 3 of 3

Calculate Hours Present and Overtime for Attendance

  1. #1
    Registered User
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    76

    Calculate Hours Present and Overtime for Attendance

    Hi,

    In the enclosed file,

    1. Column B and C are entered time in 24 hours format which is basically IN and OUT time of employees
    2. Column D is entered number of hours an employee is expected to work

    Help Needed on Below

    3. In Column C, I am doing C-B to get the hours and minutes an employee is worked but if out time is 1:00 a.m. it does not work (Refer E6)
    4. In Column F, I need to calculate the number of hours and minutes an employee has worked if Hours present > working hours

    Request help please
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    5,439

    Re: Calculate Hours Present and Overtime for Attendance

    In E3:

    =C3-B3+(C3<B3)

    format as "hh:mm"

    F3:

    =MAX(0,E3-D3/24)

    format as "hh:mm"

  3. #3
    Registered User
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    76

    Re: Calculate Hours Present and Overtime for Attendance

    Quote Originally Posted by bebo021999 View Post
    In E3:

    =C3-B3+(C3<B3)

    format as "hh:mm"

    F3:

    =MAX(0,E3-D3/24)

    format as "hh:mm"
    Thank You, It worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Based on attendance calculate overtime and absent hours in seperate sheet
    By skandxl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2018, 12:59 PM
  2. Calculate Overtime hours from daily hours
    By fuziduck in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2017, 06:39 AM
  3. Formula to calculate regular hours and overtime hours
    By judojames in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2014, 05:30 PM
  4. Replies: 2
    Last Post: 01-17-2014, 02:22 PM
  5. [SOLVED] 40 Hours per week / how to calculate overtime hours
    By hudsonic72 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2013, 02:33 AM
  6. Subtracting hours from time to calculate overtime hours
    By nabilishes in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-16-2012, 08:56 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1