Excel: Dealing with date, time and subtraction


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
Thank you and regards, Norman


This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of October 07, 2015.


For more resources for Microsoft Excel