Calculating minutes to midnight

[saraapple]

Good morning all,

Something very strange is happening to my excel calculations when I attempt to calculate minutes to midnight.
Here is my data:

Test data.xlsx
	A	B	C	D	E	F	G
1	START	END	Val Start	Val End	Time to Midnight	Time to Midnight Minutes	Correct Answer I don’t get!
2	18:30	2:15	18:30	2:15	05:30:00	2072490	330
3	18:00	3:15	18:00	3:15	06:00:00	2072520	360
4	3:50	14:30	3:50	14:30	20:10:00	2073370	1210
5	3:54	14:00	3:54	14:00	20:06:00	2073366	1206
6	3:48	13:40	3:48	13:40	20:12:00	2073372	1212
7	4:00	14:54	4:00	14:54	20:00:00	2073360
8	4:15	16:56	4:15	16:56	19:45:00	2073345
9	3:38	15:45	3:38	15:45	20:22:00	2073382
10	3:35	12:46	3:35	12:46	20:25:00	2073385
11	3:44	15:27	3:44	15:27	20:16:00	2073376
12	3:44	12:44	3:44	12:44	20:16:00	2073376
13	3:57	15:02	3:57	15:02	20:03:00	2073363
14	17:54	4:10	17:54	4:10	06:06:00	2072526
15	4:00	14:30	4:00	14:30	20:00:00	2073360
16	5:25	15:33	5:25	15:33	18:35:00	2073275
17	4:41	12:45	4:41	12:45	19:19:00	2073319
18	7:43	15:12	7:43	15:12	16:17:00	2073137
19	4:14	16:22	4:14	16:22	19:46:00	2073346
20	11:46	22:56	11:46	22:56	12:14:00	2072894
21	11:43	19:34	11:43	19:34	12:17:00	2072897
Sheet12

Cell Formulas
Range	Formula
C2:D21	C2	=VALUE(A2)
E2:E21	E2	=1440-C2
F2:F21	F2	=E2*1440

As you can see I can calculate time to midnight but when I try and convert it into minutes I get the wrong figure.
If I type the times and use the *1440 calculation it works but it will not use the data I currently have in my sheet. I have tried changing the format but nothing is working.
I am sure this is something simple but for the life of me I cannot see it!!!
If anyone can point me in the right direction I would be most grateful.
Thank you
Sara

 

[FormR]

Hi, you need to change the column E formula to

=1-C2

 

[saraapple]

Hi, you need to change the column E formula to

=1-C2

THANK YOU! I knew it would be something simple

 

[shinigamilight]

E2: =(TIME(0,0,0)+1-(C2))
F2: =(TIME(0,0,0)+1-(C2))*60


We do a +1 to flip the time to the next day if you're curious.

 

[FormR]

TIME(0,0,0)+1

Hi, Isn't that snippet the equivalent of 0+1 which is, obviously, the same as just 1?