Find the Max & Min Delay time

[vinu]

Hi All,

I have a data that has leaving times of vehicles.

What I try to achieve here is to get the Min & Max delayed time from
the scheduled leaving time.

The scheduled time is in C column and the Min & Max time in D & E
columns. Vehicle wise leaving times will start from F column until W
column.

To make it more tuff, there is No possibility to insert a column next
to vehicle leaving time.

Pls help…

Rgds,
Vinu

 

[Ms-Exl-Learner]

Hi All,

I have a data that has leaving times of vehicles.

What I try to achieve here is to get the Min & Max delayed time from
the scheduled leaving time.

The scheduled time is in C column and the Min & Max time in D & E
columns. Vehicle wise leaving times will start from F column until W
column.

To make it more tuff, there is No possibility to insert a column next
to vehicle leaving time.

Pls help…

Rgds,
Vinu

Query is not clear to me.

 

[Matt Richardson]

Hi All,

I have a data that has leaving times of vehicles.

What I try to achieve here is to get the Min & Max delayed time from
the scheduled leaving time.

The scheduled time is in C column and the Min & Max time in D & E
columns. Vehicle wise leaving times will start from F column until W
column.

To make it more tuff, there is No possibility to insert a column next
to vehicle leaving time.

Pls help…

Rgds,
Vinu

Lets say you are looking at the scheduled time in C1..

In D1, type:-

=MIN(F1:W1)

In E1 type:-

=MAX(F1:W1)

And that should give you the minimum and maximum actual leaving times
for the range F1 to W1.

Is this what you meant?

Matt
http://2toria.com
http://teachr.blogspot.com