Find the Max & Min Delay time

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
 
M

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.
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top