Dealing with date, time and subtraction

[kilosub]

Hi All,

How do I compute 10/7/2015 0:02 41023 - 10/6/2015 0:02 40773?

The time I've format it to h:mm. Below is the part of the data which is recorded hourly

a	b	c
10/7/2015	0:02	41,023.00
10/6/2015	23:02	41,012.00
10/6/2015	22:02	41,002.00
10/6/2015	21:02	40,991.00
10/6/2015	20:02	40,980.00
10/6/2015	19:02	40,969.00
10/6/2015	18:02	40,958.00
10/6/2015	17:02	40,947.00
10/6/2015	16:02	40,936.00
10/6/2015	15:02	40,925.00
10/6/2015	14:02	40,914.00
10/6/2015	13:02	40,904.00
10/6/2015	12:02	40,893.00
10/6/2015	11:02	40,882.00
10/6/2015	10:02	40,871.00
10/6/2015	9:02	40,860.00
10/6/2015	8:02	40,849.00
10/6/2015	7:02	40,838.00
10/6/2015	6:02	40,827.00
10/6/2015	5:02	40,816.00
10/6/2015	4:02	40,806.00
10/6/2015	3:02	40,795.00
10/6/2015	2:02	40,784.00
10/6/2015	1:02	40,783.00
10/6/2015	0:02	40,773.00

<tbody>
</tbody>

Thank you and regards,


Norman

 

[oldbrewer]

Date	Time	hut1	hut2	hut3				hut1	hut2	hut3									ROW1
31/08/2015	00:02	30,973.00	60,785.00	8,431.00			31/08/2015	n/a	n/a	n/a									ROW2
01/09/2015	00:02	31,262.00	61,136.00	8,549.00			01/09/2015	289	351	118									ROW3
02/09/2015	00:02	31,550.00	61,486.00	8,666.00			02/09/2015	288	350	117									ROW4
03/09/2015	00:02	31,837.00	61,835.00	8,782.00			03/09/2015	287	349	116									ROW5
04/09/2015	00:02	32,123.00	62,183.00	8,897.00			04/09/2015	286	348	115									ROW6
05/09/2015	00:02	32,408.00	62,530.00	9,011.00			05/09/2015	285	347	114									ROW7
06/09/2015	00:02	32,692.00	62,876.00	9,124.00			06/09/2015	284	346	113				hut1	hut2	hut3			ROW8
07/09/2015	00:02	32,975.00	63,221.00	9,236.00			07/09/2015	283	345	112		N9>>>>>>	01/09/2015	8228	10171	3071			ROW9
08/09/2015	00:02	33,257.00	63,565.00	9,347.00			08/09/2015	282	344	111		N10>>>>>	01/10/2015						ROW10
09/09/2015	00:02	33,538.00	63,908.00	9,457.00			09/09/2015	281	343	110									ROW11
10/09/2015	00:02	33,818.00	64,250.00	9,566.00			10/09/2015	280	342	109									ROW12
11/09/2015	00:02	34,097.00	64,591.00	9,674.00			11/09/2015	279	341	108		8228 calculated by						ROW13
12/09/2015	00:02	34,375.00	64,931.00	9,781.00			12/09/2015	278	340	107									ROW14
13/09/2015	00:02	34,652.00	65,270.00	9,887.00			13/09/2015	277	339	106		=SUMPRODUCT(($H$3:$H$39>=$N9)*($H$3:$H$39<$N10)*($I$3:$I$39))	ROW15
14/09/2015	00:02	34,928.00	65,608.00	9,992.00			14/09/2015	276	338	105									ROW16
15/09/2015	00:02	35,203.00	65,945.00	10,096.00			15/09/2015	275	337	104									ROW17
16/09/2015	00:02	35,477.00	66,281.00	10,199.00			16/09/2015	274	336	103									ROW18
17/09/2015	00:02	35,750.00	66,616.00	10,301.00			17/09/2015	273	335	102		the right hand table now autopopulates				ROW19
18/09/2015	00:02	36,022.00	66,950.00	10,402.00			18/09/2015	272	334	101		as you add new data to the left hand table				ROW20
19/09/2015	00:02	36,293.00	67,283.00	10,502.00			19/09/2015	271	333	100									ROW21
20/09/2015	00:02	36,563.00	67,615.00	10,601.00			20/09/2015	270	332	99									ROW22
21/09/2015	00:02	36,832.00	67,946.00	10,699.00			21/09/2015	269	331	98		the formula in the empty cell to the left				ROW23
22/09/2015	00:02	37,100.00	68,276.00	10,796.00			22/09/2015	268	330	97		of the cell marked ###### is					ROW24
23/09/2015	00:02	37,367.00	68,605.00	10,892.00			23/09/2015	267	329	96									ROW25
24/09/2015	00:02	37,633.00	68,933.00	10,987.00			24/09/2015	266	328	95		=IF($H40="","",E40-E39)					ROW26
25/09/2015	00:02	37,898.00	69,260.00	11,081.00			25/09/2015	265	327	94									ROW27
26/09/2015	00:02	38,162.00	69,586.00	11,174.00			26/09/2015	264	326	93		H40 will only fill if A40 is not blank				ROW28
27/09/2015	00:02	38,425.00	69,911.00	11,266.00			27/09/2015	263	325	92									ROW29
28/09/2015	00:02	38,683.00	70,259.00	11,345.00			28/09/2015	258	348	79									ROW30
29/09/2015	00:02	38,943.00	70,605.00	11,423.00			29/09/2015	260	346	78									ROW31
30/09/2015	00:02	39,201.00	70,956.00	11,502.00			30/09/2015	258	351	79									ROW32
01/10/2015	00:02	39,463.00	71,302.00	11,580.00			01/10/2015	262	346	78									ROW33
02/10/2015	00:02	39,723.00	71,643.00	11,659.00			02/10/2015	260	341	79									ROW34
03/10/2015	00:02	39,986.00	71,983.00	11,737.00			03/10/2015	263	340	78									ROW35
04/10/2015	00:02	40,247.00	72,312.00	11,816.00			04/10/2015	261	329	79									ROW36
05/10/2015	00:02	40,510.00	72,638.00	11,894.00			05/10/2015	263	326	78									ROW37
06/10/2015	00:02	40,773.00	72,960.00	11,973.00			06/10/2015	263	322	79									ROW38
07/10/2015	00:02	41,023.00	73,272.00	12,051.00			07/10/2015	250	312	78									ROW39
						H40>>>>					#####								ROW40
																			ROW41
																			ROW42
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T

<colgroup><col><col><col span="3"><col><col><col><col span="5"><col><col span="7"></colgroup><tbody>
</tbody>