+ Reply to Thread
Results 1 to 1 of 1

Formula to Calculate Downtime

  1. #1
    Registered User
    Join Date
    11-07-2018
    Location
    Indiana
    MS-Off Ver
    Office 365
    Posts
    19

    Formula to Calculate Downtime

    I have an issue with a formula. On the "Weekly Results" tab, I have two separate rows (13 & 23) that need to calculate total downtime. The caveat is that the total downtime is contingent upon the total shift (rows 14 & 24). I thought it was going to be as simple as subtracting the shift from the total load time (rows 15 & 25), but alas, it is not. Basically, the total downtime is the total shift minus the total load time. The issue I'm running into is the fact that if first shift starts early (i.e. 12 hour shift) then the downtime needs to reflect that based on the load start time on the day of the week tab. The other issue is second shift. Second shift has a firm start time, but not a firm end time. If they work over, then the formula needs to be able to find the last load of the day, and then reflect the last load time to the shift end time in the total downtime. I'm at a loss. I've included the actual spreadsheet as it has no confidential info in it. It's the only formula I'm stuck on. I don't care if there are helper columns or not. I can hide those.

    Please let me know if I didn't do a good job of explaining.
    Attached Files Attached Files

+ 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. Calculate downtime per week/month/year
    By Danielosama in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2023, 02:13 PM
  2. Workday.Intl Formula subtracting Downtime and Sundays (please HELP!)
    By ramilh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2022, 06:14 AM
  3. [SOLVED] Calculate downtime while some time ranges are excluded
    By Danielosama in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2021, 04:25 AM
  4. [SOLVED] Formaula to calculate the downtime monthwise
    By Nitinkumar in forum Excel General
    Replies: 4
    Last Post: 03-23-2016, 08:14 AM
  5. [SOLVED] calculate downtime on a running timesheet
    By sunflowersherri in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2016, 09:59 PM
  6. Calculate downtime between two dates exclude weekends
    By annice in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-09-2012, 07:19 AM

Tags for this Thread

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