Hi there, I have an Excel logbook to keep track of flying time, trying to move it to Numbers but after importing can not get the cell formula used to spleet night/day time to work. Tried everything but no avail. Here the link to a copy of the spreadsheet for who is wiling to help:
https://www.icloud.com/iw/#numbers/BAJ_eW9dk_3t_vij8LKBYY25Y463JU9v412E/LOGBOOK_ QR
Thank you!
LB,
Changing the Day expression to the following will clear the error and give the proper result:
=IF(AND(TIMEVALUE(F3)≥6÷24,TIMEVALUE(F3)<18÷24,TIMEVALUE(G3)>6÷24,TIMEVALUE(G3)≤ 18÷24),MAX(I3:J3),IF(AND(OR(TIMEVALUE(F3)≥18÷24,TIMEVALUE(F3)<6÷24),OR(TIMEVALUE (G3)>18÷24,TIMEVALUE(G3)≤6÷24)),0,IF(AND(TIMEVALUE(F3)≥6÷24,TIMEVALUE(F3)≤18÷24, OR(TIMEVALUE(G3)≥18÷24,TIMEVALUE(G3)≤6÷24)),18÷24−TIMEVALUE(F3),IF(AND(TIMEVALUE (G3)>6÷24,OR(TIMEVALUE(F3)<6÷24,TIMEVALUE(F3)≥18÷24)),TIMEVALUE(G3)−6÷24,"N/A")) ))
Regards,
Jerry
I believe that there are other changes that you will have to make, but this will get you started. What would be great for us would be for you to give us a verbal desctiption of the calculations. We're guessing on some of the fields.
Jerry
Thanks for your help Jerrold! But I tried the Day expression as you posted but no avail, still getting the error... I'm running Numbers 3.0. As I said I get this spreadsheet working like a charm in Excel, but when imported will not work on Numbers and I get the error on columns Day and Night. Basically I'll I need is to enter Takeoff and Landing time, the MEL, IFR, DAY, NIGHT, CROSS CTRY, PIC and TOTAL will be filled automatically with the flight time, don't need the remaining cells. All of them except the DAY and NIGHT cells are easy to manage and are working well once the are the total flight time, now I can not make the DAY and NIGHT formula work on Numbers as they do in Excel.
Regards
What I get from your formula with the TIMEVALUE is syntax error.
Regards
LB,
Send me an email and I will send back a copy of the document using my expression and not displaying an error.
It's such a long expression that there could be problems getting it imput properly, even with Copy and Paste.
If you would give me the verbal description of the expressions's purpose, I may be able to simplify it.
Jerry
Thanks again Jerrold, the day and night cells are simple to explain but really hard to accomplished, actually was not me the one to come up with that formula. Basically you enter the Takeoff time on F3 and Landing time at G3, the Day cell will show the amount of time flow between 6AM and 6PM while Night row will calculate the Night time flight flown between 6PM and 6AM. That "simple".... Just beyond my knowledge to figure out how to do it.... If you can help simplify it would be great once the formula from a friend of mine is really crazy!!LOL
Regards!
LB,
What is the longest continuous flight that might be logged?
Jerry
I guess 20 hours....
Thanks
Thanks,
That limits the complexity a bit. Less than 12 would have been even easier. 🙂
Thanks,
Jerry
Need help importing excel into numbers.
