+ Reply to Thread
Results 1 to 14 of 14

need formula to calculate hours worked

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    379

    need formula to calculate hours worked

    Hi

    how do i calculate the hours worked per shift

    D
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 2013
    Posts
    108

    Re: need formula to calculate hours worked

    Please try this in Col C

    =B2+1-A2

  3. #3
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: need formula to calculate hours worked

    Perfect thank you

  4. #4
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: need formula to calculate hours worked

    how would i calculate the total hours in a pivot by year/month as it not coming out what is should ?

    see attached
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 2013
    Posts
    108

    Re: need formula to calculate hours worked

    Though it looks perfect to me, but I change the piviot layout by Year/Month total... is this what u r looking for..?
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: need formula to calculate hours worked

    the hours dont add up correct though do they ?

  7. #7
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 2013
    Posts
    108

    Re: need formula to calculate hours worked

    its showing me the 4723:14:00 in both the sheets, which is correct... are u expecting something different..?

  8. #8
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: need formula to calculate hours worked

    go to the data tab and add up the month of aug 2019 its not matching what pivot says ?

  9. #9
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 2013
    Posts
    108

    Re: need formula to calculate hours worked

    both data and piviot are showing 504:14:00 for Aug'19

  10. #10
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: need formula to calculate hours worked

    yeah but it we count the hours manually - its not the total
    01:00
    10:59
    12:15
    12:15
    11:00
    12:15
    11:15
    11:30
    12:15
    12:15
    12:15
    12:15
    12:15
    12:15
    12:15
    12:15
    12:15
    12:15
    12:15
    11:00
    12:00

  11. #11
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 2013
    Posts
    108

    Re: need formula to calculate hours worked

    Please use ABS(C2-B2) as the formula in D2 and drag and refresh the piviot..

  12. #12
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 2013
    Posts
    108

    Re: need formula to calculate hours worked

    Quote Originally Posted by amitmodi_mrt View Post
    please use abs(c2-b2) as the formula in d2 and drag and refresh the piviot..
    =abs(c2-b2)

  13. #13
    Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    282

    Re: need formula to calculate hours worked

    Assuming that if finish time is less than Starting time, then finish time is the next day.
    If finish time is greather than starting time, then both times are the same day
    For that case this formula does the correct working times:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Kind regards,
    Piet Bom

  14. #14
    Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    282

    Re: need formula to calculate hours worked

    @dougers1,
    Was this what you wanted ?

+ 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: 1
    Last Post: 04-30-2018, 01:27 PM
  2. [SOLVED] Formula to calculate hours worked
    By LilMissM in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-13-2014, 06:08 PM
  3. [SOLVED] Formula To Calculate Hours Worked In a Day
    By SilverFox in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2013, 05:21 AM
  4. Replies: 4
    Last Post: 02-12-2013, 07:01 AM
  5. Replies: 2
    Last Post: 02-11-2013, 02:26 PM
  6. Formula to calculate hours worked
    By mikeburg in forum Excel General
    Replies: 6
    Last Post: 05-06-2008, 04:02 PM
  7. Need formula to calculate hours worked
    By BankC in forum Excel General
    Replies: 12
    Last Post: 01-31-2006, 01:38 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