I have 5 times fields the start times are in columns A & B and the end times
are in Columns C, D & E. They are not in order, but cols A or B are always <
C, D or E. How can I get the #of minutes between the earliest start time and
latest of the end times.
thank you zb

=MAX(C10:E10)-MIN(A10:B10) and format the cell as [mm].


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Zb Kornecki" wrote:

I have 5 times fields the start times are in columns A & B and the end times
are in Columns C, D & E. They are not in order, but cols A or B are always <
C, D or E. How can I get the #of minutes between the earliest start time and
latest of the end times.
thank you zb

Try this:

=MAX(C1:E1)-MIN(A1:B1)

this will give the answer in time format - you may need to format the
cell as [m]:ss if you want the answer in minutes.

Alternatively, multiply the answer by 24 and by 60 and format the cell
as General or Number with 2 dp.

Hope this helps.

Pete

On Mar 8, 12:44 am, Zb Kornecki <zDOTkorneckiATcomcastDOTnet wrote:
I have 5 times fields the start times are in columns A & B and the end times
are in Columns C, D & E. They are not in order, but cols A or B are always <
C, D or E. How can I get the #of minutes between the earliest start time and
latest of the end times.
thank you zb