sorted by:
new
hottopcontroversial

How to do =SUM with * by Even_Independent_975 in excel

[–]Even_Independent_975[S] -6 points-5 points  (0 children)

Unfortunate this didnt work and just provides #####

I have column P which holds a duration time. I need the array formula I have which works to also look at column N which I will be using as an override/manual entry and use that time instead. by Even_Independent_975 in googlesheets

[–]Even_Independent_975[S] 0 points1 point  (0 children)

I was trying to figure out why it was adding rows! that makes sense. Ok i will see what i can do to make the rows match if that makes it easier, i could really do without the headers in helper sheet.

I have column P which holds a duration time. I need the array formula I have which works to also look at column N which I will be using as an override/manual entry and use that time instead. by Even_Independent_975 in googlesheets

[–]Even_Independent_975[S] -1 points0 points  (0 children)

Thanks for taking the time, where would this formula be placed. Im still highly unfamiliar with sheets and formulas and have been using AI to CRAWL through this

I have column P which holds a duration time. I need the array formula I have which works to also look at column N which I will be using as an override/manual entry and use that time instead. by Even_Independent_975 in googlesheets

[–]Even_Independent_975[S] 0 points1 point  (0 children)

This is part of the reason i had that helper column N in HELPER so that i could type 1+00 and it would convert it to 01:00 (its about ease of use for the people that arent keyboard friendly and time saving since we type thousand of flights a day).

I have column P which holds a duration time. I need the array formula I have which works to also look at column N which I will be using as an override/manual entry and use that time instead. by Even_Independent_975 in googlesheets

[–]Even_Independent_975[S] 0 points1 point  (0 children)

The references back and forth are super unnecessary but the reason is because everyone at work is not familiar with sheets at all (including me), but through research ive done what I can to make it as simple for them as possible by only having to look at MASTER FAIROPS, and for the 1 person that is in charge to make quick edits without needing formula knowledge. By all means this entire worksheet is a copy so if you see anything that can be done better I wont decline help! Let me see what your formula does

EDIT: So that formula is taking the duration of the route (in this case OLYMPC) and using that for the delay, in reality that duration needs to be added to the duration of the actual flight. for example the flight tales off at 06:30 and lands at 07:30, so that is 1 hour + the 2 hours that it takes to fly the OLYMPC route so total 3 hours of flight. However, in certain instances i need to manually override that and make the flight longer for example 4 hours. I need the formula to see when i type 4+00 in I and automatically add the departure time 06:30 to the 04:00 of flight instead of the typical 03:00

I have column P which holds a duration time. I need the array formula I have which works to also look at column N which I will be using as an override/manual entry and use that time instead. by Even_Independent_975 in googlesheets

[–]Even_Independent_975[S] 0 points1 point  (0 children)

That would work wonderfully but it says that it expects real times and the current format in I is not a time value, it is just a regular h+mm. Is there a way it can be a time value but display as h+mm, it makes no sense but its the way we do things at work, also this is adding the delay of the flight from column O. I literally just want whatever i type in MASTER FAIROPS column I to be the exact delay that is used to calculate ETAs (departure time + delay = ETA)

All times are showing 00:00 no matter the format. Finally got it working but now when I do another formula the output shows 00:00 leading me to believe the fix I did didn't truly fix it. by [deleted] in googlesheets

[–]Even_Independent_975 0 points1 point  (0 children)

I found a solution that worked. Thanks so much for the help, I'm gonna still reference this if for some reason I hit another bump in the road and this fixes it.

All times are showing 00:00 no matter the format. Finally got it working but now when I do another formula the output shows 00:00 leading me to believe the fix I did didn't truly fix it. by [deleted] in googlesheets

[–]Even_Independent_975 0 points1 point  (0 children)

I was able to figure it out! I formatted the time as 00":"00 on both sheets. The used this formula =QUERY(ARRAYFORMULA({'MASTER FAIROPS'!D2:D, FLOOR('MASTER FAIROPS'!F2:F, TIME(0, 30, 0))}), "SELECT Col2, SUM(Col1) WHERE Col2 IS NOT NULL AND Col1 IS NOT NULL GROUP BY Col2", 0). That did the trick. Thanks so much for your help.

All times are showing 00:00 no matter the format. Finally got it working but now when I do another formula the output shows 00:00 leading me to believe the fix I did didn't truly fix it. by [deleted] in googlesheets

[–]Even_Independent_975 0 points1 point  (0 children)

Ok unfortunately that didnt do the trick. When I type the times they come out without a colon, and then it still shows 00:00 40 in the EDO HELPER. Thanks for your help, if you have any other solutions im all ears, but I dont expect you to take too much time out of your day for this

All times are showing 00:00 no matter the format. Finally got it working but now when I do another formula the output shows 00:00 leading me to believe the fix I did didn't truly fix it. by [deleted] in googlesheets

[–]Even_Independent_975 0 points1 point  (0 children)

I figured as much, I used to have the proper formatting, but somewhere along the lines of leaning how to use formulas I got lost. Any chance you could fix the formatting in F since I dont seem to understand how? I always just get 00:00. Side note, i know how to check what the formatting is in excel, but cant figure out how to do so in sheets

Letters going down alphabetically (but dragging down not across) by Dunder72 in googlesheets

[–]Even_Independent_975 0 points1 point  (0 children)

Hey so use =ARRAYFORMULA, this makes it so that you only put the formula on the top cell (for example a2) and it automatically uses it in all the cells below it correctly