Hi how can I add: Dep 17:00 Arrival 19:15 Flight Time 2.2

Question

Level 1

5 points

Hi how can I add: Dep 17:00 Arrival 19:15 Flight Time 2.2

MINUTES TO TENTHS CONVERSION	00 - 05 = .0	06 - 11 = .1	12 - 17 = .2	18 - 23 = .3	24 - 29 = .4
MINUTES TO TENTHS CONVERSION	30 - 35 = .5	36 - 41 = .6	42 - 47 = .7	48 - 53 = .8	54 - 59 = .9
DELAY TYPE CODES	A=ATC	C=CREW	M=MAINT	P=PAX	W=WX	O=OTHER

iPad Air Wi-Fi, iOS 9

Posted on Sep 26, 2015 12:33 AM

Reply

Answer 1

Yellowbox

Level 7

21,945 points

Sep 26, 2015 2:30 AM in response to gomlic

Hi gomlic,

Numbers has a Date & Time cell format. Any time carries a date (even if not displayed) and every date caries a time (even if not displayed).

Date & Time is an instant since midnight at the beginning of 1st January in the year 1904. Here is an illustration displaying full Date & Time in the Depart and Arrive columns.

Subtracting Arrival -Departure gives a Duration

Please restate your problem. I am not sure why you want tenths.

Regards,

Ian.

Reply

Answer 2

Sep 26, 2015 12:19 PM in response to gomlic

The first column is integers from 0 to 60 (column A)

the second column ( column B) contains the formula:

=INT(A2÷6)÷10

select cell B2, then type (or copy and paste from here) the formula:

=INT(A2÷6)÷10

shorthand is:

B2=INT(A2÷6)÷10

Minutes	Tenths
0	0
1	0
2	0
3	0
4	0
5	0
6	0.1
7	0.1
8	0.1
9	0.1
10	0.1
11	0.1
12	0.2
13	0.2
14	0.2
15	0.2
16	0.2
17	0.2
18	0.3
19	0.3
20	0.3
21	0.3
22	0.3
23	0.3
24	0.4
25	0.4
26	0.4
27	0.4
28	0.4
29	0.4
30	0.5
31	0.5
32	0.5
33	0.5
34	0.5
35	0.5
36	0.6
37	0.6
38	0.6
39	0.6
40	0.6
41	0.6
42	0.7
43	0.7
44	0.7
45	0.7
46	0.7
47	0.7
48	0.8
49	0.8
50	0.8
51	0.8
52	0.8
53	0.8
54	0.9
55	0.9
56	0.9
57	0.9
58	0.9
59	0.9
60	1
61	1