Find the Max & Min Delay time

  • Thread starter Thread starter vinu
  • Start date Start date
V

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
 
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
Click to expand...


Query is not clear to me.
 
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
Click to expand...

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
 
Back
Top