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.

Hi Scott,
Check Chip web you will find everything related to time calculations

http://www.cpearson.com/excel/datetime.htm

"Scott R" wrote:

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.

Thanks

That did the trick.

Scott

"Eduardo" wrote:

Hi Scott,
Check Chip web you will find everything related to time calculations

http://www.cpearson.com/excel/datetime.htm

"Scott R" wrote:

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.