=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