+ Reply to Thread
Results 1 to 2 of 2

Assign value or point for each active hour..

  1. #1
    Registered User
    Join Date
    02-07-2019
    Location
    CA
    MS-Off Ver
    2010
    Posts
    1

    Assign value or point for each active hour..

    Hello everyone,
    I'm having an issue that I think I almost have solved but I just cant get it.

    Here is my problem:

    I am trying to assign a point or value for each hour a flight is active. What I mean by active is from scheduled departure time to scheduled arrival time.

    For example.

    ABC123 is scheduled to depart at 0000 and scheduled to arrive at 0426
    For example, in cell A1, I have 0000 and B1 I have 0426. Note that the cells are formatted as text.

    Now, in a different table, and where my problem is, I want it to recognize each hour the flight is active and assign a point to that hour block.
    So for this example, I want it to assign a value to block 0000, block 0100, 0200, 0300 and 0400 because the flight is only active within those hour blocks. I also need the formula to count other flights that could also be active within those hours.
    I think I need to use a COUNTIFS or a LOOKUP function, or a combination of both.

    Your help is much appreciated, thanks!

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Assign value or point for each active hour..

    Can you attached file with some sample data and expected results, please?
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. Need to randomly assign advisors to half hour meetings without repeating
    By lrcahi02 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2018, 02:02 AM
  2. Assign a point value to a response in another cell
    By Geot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2017, 10:39 AM
  3. Assign value associated with a point to a range
    By zxcity in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-18-2013, 09:10 AM
  4. Assign point values to ranks
    By JustinN1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2013, 05:18 PM
  5. How to assign a value to a data point
    By Bill Brasky in forum Excel General
    Replies: 10
    Last Post: 09-05-2012, 03:57 PM
  6. Deducting h:mm ' from a 50 hour start point
    By nje in forum Excel General
    Replies: 8
    Last Post: 06-25-2010, 04:16 AM
  7. How do I assign point values on survey answers?
    By MikeM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2006, 12:55 PM

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