+ Reply to Thread
Results 1 to 4 of 4

Computing the Hours Worked

  1. #1
    Registered User
    Join Date
    05-22-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    34

    Unhappy Computing the Hours Worked

    Good Day!

    I have attached a file. In our office we have an 8hr workday that's 8am-5pm. However, we have this what we call as flexitime wherein we can come to work late for up to 30mins that's up to 8:30 provided that we will go out 30mins late as wee that's up to 5:30.. We also have a 1hr (12nn-1pm) lunch break from which we can time in/out between 12NN-1PM.

    My problem is: how to compute for the total number of work hours and minutes (this is in case the employee goes undertime or beyond flexitime)?

    thanks!
    Attached Files Attached Files
    Last edited by kraddark; 05-23-2011 at 02:13 AM. Reason: changed file attachment

  2. #2
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Re: Computing the Hours Worked

    You could use this for the minutes:
    =TEXT((B6-A6)+(D6-C6),"mm:ss")

    And this can give you the hours:
    =TEXT((B6-A6)+(D6-C6),"h")

    Drag down as required. If you get a #Value! error it's because you are dealing with incorrect times. For instance, B10 contain 12:00PM, you need to put a space between the time and the "PM". D9 and D10 contain AM, that should be PM otherwise you'll get errors.
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

  3. #3
    Registered User
    Join Date
    05-22-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Computing the Hours Worked

    sorry about the inconsistencies on the file attachment. I have attached an updated file.

    it seems like it was not the output that I am looking for, in the new file I have included the desired output and explained why it should be the output. thanks for your patience.
    Last edited by shg; 05-23-2011 at 07:58 PM. Reason: deleted quote

  4. #4
    Registered User
    Join Date
    05-22-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Computing the Hours Worked

    sorry about the inconsistencies on the file attachment. I have attached an updated file.

    it seems like it was not the output that I am looking for, in the new file I have included the desired output and explained why it should be the output. thanks for your patience.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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