Results 1 to 2 of 2

Calculating Downtime taking into acount 3 possible shifts of production.

Threaded View

Clintp1111 Calculating Downtime taking... 11-07-2013, 04:21 PM
amit.wilson Re: Calculating Downtime... 11-12-2013, 12:16 AM
  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    SC, USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Calculating Downtime taking into acount 3 possible shifts of production.

    Hello,

    I would like to determine downtime in hours between two dates and times. In the attached excel sheet I have where you can enter the date and time down in B5 and date and time up in F5. On the shift hours tab it shows the hours for all three shifts. I would like for H5-J5 on the original tab to have formulas to display hours for each shift the machine has been down for. If anyone can help thanks alot.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help calculating Downtime
    By Ben.Cgg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2013, 05:02 PM
  2. Need help in calculating downtime
    By Nitinkumar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2013, 09:58 AM
  3. Replies: 8
    Last Post: 02-21-2012, 01:38 PM
  4. Calculating the remaining shifts for a week?
    By tavlrb in forum Excel General
    Replies: 1
    Last Post: 03-05-2011, 07:47 AM
  5. Calculating Costs over varying shifts
    By AussieFreelance in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2007, 08:39 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