Search:

Type: Posts; User: rgsanchez; Keyword(s):

Search: Search took 0.00 seconds.

  1. Sumifs, Lists, and Sumproduct to create a matrix?

    Hello,
    I am trying to create a matrix that includes specific data from different Excel workbooks. However, since I don't know how to use macros, I'm going to transfer data from each workbook to the...
  2. Re: Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

    Hi Toadstool,
    Your function in F3 solved my issue! Typically a train will never be later, and definitely not earlier, than even 5 hours. Trains that are more than 3 hours late typically just get...
  3. Replies
    1
    Views
    104

    VLOOKUP a date+time with only a date

    Can I Vlookup a date+time if I only have the time? For example, I have the Scheduled Time only in Table B. I want to Vlookup the Date+Time from Table A.


    <tbody>
    Table A: Reference Table

    ...
  4. Re: Need formula for Elapsed Time (negative values, times after midnight)

    Actually, I don't know how to delete it! Sorry for the double post.
  5. Re: Need formula for Elapsed Time (negative values, times after midnight)

    Thanks, Toadstool. I am new to Mr. Excel and I accidentally posted in the wrong forum at first. I will delete this post above.
  6. Re: Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

    Hi Toadstool,
    Thank you for your response, but I am looking for a solution that does not require me to use the full dates, as that would mean I'd have to make changes to my raw data.
    I did see a...
  7. Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

    Hello,
    I need to calculate how many minutes early/late a train arrived. I am comparing the scheduled train arrival, versus the actual train arrival. I have tried many formulas, but can't find a...
  8. Need formula for Elapsed Time (negative values, times after midnight)

    Hello,
    I need to calculate how minutes late/early a train arrived (elapsed time) by comparing the scheduled arrival time with the actual arrival time. I have tried many different ways of doing this,...
  9. Re: Can I combine AVERAGEIFS, SUMPRODUCT, and AND?

    Eric, thank you so much! I was able to use your method for my analysis.:)
  10. Re: Can I combine AVERAGEIFS, SUMPRODUCT, and AND?

    Wow, thank you,Eric! I had been at it for hours! Also, thank you for the welcome. Can you also think of a way to get the AVERAGE using the same two criteria?
  11. Can I combine AVERAGEIFS, SUMPRODUCT, and AND?

    <tbody>
    Day
    Train
    Passengers


    Fri
    702
    5
Results 1 to 11 of 11