+ Reply to Thread
Results 1 to 3 of 3

Calculating Late/Tardy per interval to FTE equivalent

  1. #1
    Registered User
    Join Date
    01-05-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    1

    Calculating Late/Tardy per interval to FTE equivalent

    Hi,


    We have been trying to calculate tardiness/late in our workplace. What we need is the total hours per interval that is missing. ex. Employee 1 starts at 8:00AM and came in 8:29AM and Employee 2 starts at 8:00AM and came in at 8:31AM, We should show in 8:00 interval that we have 29 mins + 30 mins late hours and on the 8:30 interval we should show 1 min late hours. any suggestions. How do we compute for the total lost hours per interval. attached is file sample in progress.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-14-2020
    Location
    Quezon City Philippines
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Re: Calculating Late/Tardy per interval to FTE equivalent

    Is there a way to make the sumproduct calculate the total hours per interval instead of the FTE equivalent?

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,676

    Re: Calculating Late/Tardy per interval to FTE equivalent

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

+ 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] Time calculation for attendance, tardy/late to work?
    By Hanr3 in forum Excel General
    Replies: 7
    Last Post: 12-08-2015, 06:16 AM
  2. Formula to calculating late arrivals...
    By drewkenna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2014, 09:53 AM
  3. Calculating interest with late fees
    By importantverbs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-16-2011, 08:41 PM
  4. Calculating # of days early or late
    By ssmith0011984 in forum Excel General
    Replies: 4
    Last Post: 09-11-2008, 04:05 PM
  5. Calculating Late Charges and Intrest
    By deezeejoey in forum Excel General
    Replies: 2
    Last Post: 06-17-2008, 04:34 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