+ Reply to Thread
Results 1 to 2 of 2

Calculate task duration minus breaks

  1. #1
    Registered User
    Join Date
    04-24-2020
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    2

    Calculate task duration minus breaks

    Hi, I need to calculate the duration of tasks within a shift minus the lunch and dinner breaks which are at set times, the issue I have is when the task starts after the end time of the break the answer is returned as a negative as seen in F3 in the attached sheet, thanks
    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,446

    Re: Calculate task duration minus breaks

    Hi
    this problem has been asked many times on the board and elsewhere.
    Might I suggest you search those two sources first so that our members should not have to waste their time.
    Thanks

+ 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. is there a task duration formula
    By jramsey18 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-25-2019, 12:32 AM
  2. [SOLVED] Project task duration visualization problem
    By Villalobos in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-03-2017, 12:25 PM
  3. Plotting a Task(s) on a day(s) w/start time and duration.
    By sorensjp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-04-2016, 06:50 PM
  4. Workinghours minus 3 breaks
    By IKZOUHETNIETWETEN in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 02-24-2013, 07:21 AM
  5. Duration of a Task
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2013, 08:14 PM
  6. [SOLVED] Formula: To calculate duration between two times, if duration is over 6hours subtract 30mi
    By MattBarnes7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 03:22 PM
  7. time minus duration
    By w1lls in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-22-2011, 09:48 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1