Trying to create page to automatically populate and calculate reaction time by subtracting time

The last line cel derives its information from another pre-populated cel using the = sign.

Reaction time is 1st box minus last line.

The 1st box is filled in as the last variable for calculation…

 

 

 

 

Last Line 1st Box Reaction Time
6/1/2018 7:30 6/1/2018 7:58 0:28
6/5/2018 11:00 6/5/2018 11:56 0:56
6/6/2018 9:30 6/6/2018 10:45 1:15
6/6/2018 16:55 6/6/2018 17:45 0:50
6/7/2018 0:15   #############
6/7/2018 21:45   #############
6/11/2018 7:30   #############
6/12/2018 15:40   #############
6/13/2018 17:50   #############
6/15/2018 1:15   #############
6/15/2018 18:15   #############
6/18/2018 20:50   #############
6/19/2018 8:00   #############
6/22/2018 7:45   #############
6/25/2018 7:25   #############
6/26/2018 7:25   #############
6/27/2018 2:20   #############
6/28/2018 18:30   #############
6/29/2018 21:20   #############
6/30/2018 3:55   #############

By: Ricky Beaujon

Leave a Reply

Your email address will not be published. Required fields are marked *