Any Apple numbers app experts ?
Thread Starter
Joined: Jan 2006
Posts: 44
Likes: 0
From: uk
Any Apple numbers app experts ?
Hi all,
as per the title, any Apple numbers app experts out there ? I’ve used a basic excel spreadsheet for my logbook for years, then went to a Mac and used same file but via open office, now going to iPad only and want to use the numbers app to continue the logbook. I can export it as a numbers file off open office and open in numbers most of it works fine.
first question, how do I format a whole column so it’s just date ie dd/mm/yyyy ?
similar for q2, how do I format a whole column for just hh:mm for take off and landing time ?
then the more tricky one. I had one column for take, one column for landing next column for flight time. In excel I’ve used the equations of
=if(k3707-k3707>};(k3707-j3707);(k3707-j3707)+1)
where j3707 is take off time, k3707 landing time to calculate over midnight eg take off 2300 land 0400. It works fine in excel generating correct time but on the iPad numbers app, any flight overlapping midnight just returns a 10 or so digit number. Baffled.
anyone any ideas please ?
as per the title, any Apple numbers app experts out there ? I’ve used a basic excel spreadsheet for my logbook for years, then went to a Mac and used same file but via open office, now going to iPad only and want to use the numbers app to continue the logbook. I can export it as a numbers file off open office and open in numbers most of it works fine.
first question, how do I format a whole column so it’s just date ie dd/mm/yyyy ?
similar for q2, how do I format a whole column for just hh:mm for take off and landing time ?
then the more tricky one. I had one column for take, one column for landing next column for flight time. In excel I’ve used the equations of
=if(k3707-k3707>};(k3707-j3707);(k3707-j3707)+1)
where j3707 is take off time, k3707 landing time to calculate over midnight eg take off 2300 land 0400. It works fine in excel generating correct time but on the iPad numbers app, any flight overlapping midnight just returns a 10 or so digit number. Baffled.
anyone any ideas please ?
Joined: Mar 2002
Aviation Qualifications: CPL
Posts: 3,392
Likes: 325
From: near an aeroplane
I'm not a numbers guru, but a quick Google sent me to this page, which explains how to set the format for a particular cell or range of cells: Format dates, currency and more in Numbers on Mac – Apple Support (UK)
The last two options three (Date & Time and Durations) are the ones you need. The tricky thing is setting the format in such a way that it sticks to the cell(s). I would have a go at changing the cell format for the outcome of your equations to show a duration and see if that produces a correct output. If not, you may need to delve into the vagaries of date and time calculations in Numbers. I suspect that, just like in Excel, there is a simple number in the background that gets translated to a date/time based on the cell format. I do hope they use the same number format with whole numbers for days and fractions for the time element.
The last two options three (Date & Time and Durations) are the ones you need. The tricky thing is setting the format in such a way that it sticks to the cell(s). I would have a go at changing the cell format for the outcome of your equations to show a duration and see if that produces a correct output. If not, you may need to delve into the vagaries of date and time calculations in Numbers. I suspect that, just like in Excel, there is a simple number in the background that gets translated to a date/time based on the cell format. I do hope they use the same number format with whole numbers for days and fractions for the time element.
