+ Reply to Thread
Results 1 to 14 of 14

the hours of operation of two device

Hybrid View

  1. #1
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: the hours of operation of two device

    I think you'll need to provide more info, what exactly do you need? It could be as simple as adding both totals together and deducting from 24 with a min in there to show zero, such as =MIN(0, total1 + total2)

    but we really need more info before giving a definitive answer. Can you fill out some of the expected results?
    If someone has helped you then please add to their Reputation

  2. #2
    Registered User
    Join Date
    09-16-2015
    Location
    dwcw
    MS-Off Ver
    11
    Posts
    7

    Re: the hours of operation of two device

    it monitors the operating hours of two pumps, we have one pump marked with HA1 and the second pump marked with HA2. On the column marked with "Pornit", write the time when the pump was started and on the column with "Oprit", write the time when it was stopped, they are recorded in the time interval 0 to 24 hours on a single day. there are several queues because in a day the pumps are turned on several times a day depending on the needs. then it is calculated independently for each cat that worked. Now I want to know how long the pumps stopped in the time interval from 0 am to 24 am, to see how much energy was not consumed from the system. the hours of energy consumption overlap, so it cannot be calculated twice, but must be calculated only as long as both have stopped
    Attached Files Attached Files
    Last edited by zcytunoy; 09-07-2022 at 07:37 AM.

+ 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. Can this be done? Timeline Slicer by hour not day
    By dttodgg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2019, 02:43 AM
  2. Device downtime calculation during performance measure hours
    By tasha2515 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-11-2018, 05:16 PM
  3. [SOLVED] Calculating Downtime During Hours of Operation
    By Puni in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2018, 11:00 PM
  4. Hours of Operation Coding
    By milwaukee in forum Excel General
    Replies: 1
    Last Post: 09-14-2015, 03:33 AM
  5. [SOLVED] SLA Counter Formual based on operation hours
    By rpc06 in forum Excel General
    Replies: 7
    Last Post: 09-25-2014, 05:42 AM
  6. [SOLVED] SLA Counter Formual based on operation hours
    By rpc06 in forum Excel General
    Replies: 1
    Last Post: 09-23-2014, 10:15 PM
  7. Replies: 4
    Last Post: 06-10-2013, 10:54 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