+ Reply to Thread
Results 1 to 2 of 2

Instantaneous Value at each hour from Start and end time .

  1. #1
    Registered User
    Join Date
    10-17-2020
    Location
    Linz
    MS-Off Ver
    Office 365
    Posts
    1

    Instantaneous Value at each hour from Start and end time .

    I have to generate a graph showing the instantaneous value of power at each hour of the day from the following data .
    (It shows the power of each device and the start and end time of its usage)

    Capture.JPG


    How can i generate or capture the value at each hour of the day only from this data ?

    P.S : I had posted in Stackoverflow without any response , so if anyone can help me with this, it would be really appreciated!
    Attached Files Attached Files
    Last edited by vikidev94; 10-17-2020 at 09:05 AM.

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Instantaneous Value at each hour from Start and end time .

    Try this

    In K5:K28 put the hour, starting from the min of Time of start
    In L5 use the following formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    See the file
    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. Replies: 1
    Last Post: 12-19-2017, 10:46 AM
  2. Replies: 5
    Last Post: 07-29-2016, 03:15 AM
  3. [SOLVED] Formula to automatically adjust lunch hour based on start time
    By Zyphon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2015, 07:23 AM
  4. Replies: 0
    Last Post: 03-07-2014, 11:26 AM
  5. Peak Day AND Hour of Day from Start Time & End Time
    By macogley in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-25-2013, 03:24 PM
  6. Replies: 3
    Last Post: 03-27-2012, 01:07 PM
  7. [SOLVED] how to calculate time start & time finish in quarter hour
    By Peter Wu in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 08:10 PM

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