# Search:

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

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

by rgsanchez
Replies
0
Views
78

### 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. ## Thread: Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

by rgsanchez
Replies
5
Views
221

### Re: Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

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. ## Thread: VLOOKUP a date+time with only a date

by rgsanchez
Replies
1
Views
102

### 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. ## Thread: Need formula for Elapsed Time (negative values, times after midnight)

by rgsanchez
Replies
3
Views
750

### 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. ## Thread: Need formula for Elapsed Time (negative values, times after midnight)

by rgsanchez
Replies
3
Views
750

### 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. ## Thread: Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

by rgsanchez
Replies
5
Views
221

### Re: Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

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. ## Thread: Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

by rgsanchez
Replies
5
Views
221

### 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. ## Thread: Need formula for Elapsed Time (negative values, times after midnight)

by rgsanchez
Replies
3
Views
750

### 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. ## Thread: Can I combine AVERAGEIFS, SUMPRODUCT, and AND?

by rgsanchez
Replies
4
Views
688

### Re: Can I combine AVERAGEIFS, SUMPRODUCT, and AND?

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

by rgsanchez
Replies
4
Views
688

### 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. ## Thread: Can I combine AVERAGEIFS, SUMPRODUCT, and AND?

by rgsanchez
Replies
4
Views
688

### Can I combine AVERAGEIFS, SUMPRODUCT, and AND?

<tbody>
Day
Train
Passengers

Fri
702
5
Results 1 to 11 of 11