Results 1 to 14 of 14

the hours of operation of two device

Threaded View

  1. #3
    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.

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