I need to determine elapsed time between a start time and the time of the
final event in a sequence. My start time is in column A but my end time may
be in one of 6 different column (depending on how many readings were taken
during the sequience). I know that if I use the formula mod (B1-A1,1)*1440 I
get the elapsed time between two readings. Is there a way to calculate the
elapsed time with a macro that selects correct column? I have a macro to
select the column I just need a calculation for the elapsed time.