+ Reply to Thread
Results 1 to 3 of 3

Count Worked Hours?

  1. 01-30-2014, 08:31 AM #1
    eng_hamada_4u
    eng_hamada_4u is offline
    Registered User
    Join Date
    01-30-2014
    Location
    khobar
    MS-Off Ver
    Excel 2003
    Posts
    1

    Count Worked Hours?

    Hi,
    I want to make formula to get total hrs in cell N11.

    Please help me.

    Thanks,
    M.Hassan

    hrs.png
    Reply With QuoteRegister To Reply
  2. 01-30-2014, 08:46 AM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Count Worked Hours?

    Hello eng_hamada_4u,

    Welcome to the Forum.

    The Picture you have uploaded does not work. It would be better if you could upload a sample Workbook, for us to have a look at for you.

    Thank you.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  3. 01-30-2014, 09:04 AM #3
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Count Worked Hours?

    Assuming your work hours are 09:00 to 17:00 Monday to Friday then try this formula in N11

    (NETWORKDAYS(J11,L11)-1)*("17:00"-"9:00")+M11-K11

    Custom format N11 as [h]:mm and you should get the result 34:00 for your example
    Audere est facere
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours
    By nikkiw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2013, 07:01 AM
  2. Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours
    By nikkiw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2013, 02:26 PM
  3. [SOLVED] Punch-Time Data. Calculating # of hours worked and # of hours worked alone per shift.
    By Daga3 in forum Excel General
    Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  4. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  5. Excel 2007 : Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel General
    Replies: 0
    Last Post: 01-05-2012, 06:23 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1