+ Reply to Thread
Results 1 to 4 of 4

Calculate total ST and OT hours for a certain date for all employees

  1. #1
    Registered User
    Join Date
    03-18-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    7

    Calculate total ST and OT hours for a certain date for all employees

    Hello Experts!!!!

    I have two tables EMP as a master table and log time as a transaction table.

    EMP has emp code and ST hours for each employee, all emp code uniquie. Log time can have same employee multiple times. I need to calculate total ST hours and OT hours for a certain date for all employees that worked on that day.

    Table structure and details in attached image.

    Appreciate your help.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Calculate total ST and OT hours for a certain date for all employees

    Hi and welcome
    not everyone understands professional jargon OT? ST? EMP?
    Please make your title understandable by us mere mortals, thank you.

  3. #3
    Registered User
    Join Date
    03-18-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    7

    Re: Calculate total ST and OT hours for a certain date for all employees

    Sure!!!

    ST hours are standard hours employees are required to work ...OT are hours worked above ST hours

    EMP is Employees Master table.

    Hope that helps

  4. #4
    Registered User
    Join Date
    03-11-2020
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    4

    Re: Calculate total ST and OT hours for a certain date for all employees

    Hi A_5426,

    Based on the file you attached. plug in the formula below.

    Cell C4 then ctrl+shift+enter
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Cell B4
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Cell D4
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    then drag the formula down

    Hope this fix your problem.

+ 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. [SOLVED] Formula to calculate hours worked w/lunch or w/o + OT column only total after 40 hours
    By blinhart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2023, 11:14 AM
  2. [SOLVED] Calculate Total Hours/Minutes between Min and Max Date in a column
    By paula.mccall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2020, 09:56 PM
  3. [SOLVED] Calculate total hours worked between 2 date/time stamps ignoring weekends and holidays
    By drewship in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2015, 09:59 AM
  4. VB Code to calculate weekly hours for employees
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2014, 07:31 AM
  5. Replies: 6
    Last Post: 01-30-2014, 06:58 AM
  6. [SOLVED] Fulltime Employees (FTEs) Total Hours Minus (-) Holidays
    By mycon73 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2013, 05:41 PM
  7. Calculate total Hours between 2 date and time
    By Tylim in forum Excel General
    Replies: 3
    Last Post: 05-08-2006, 10:20 PM

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