please help w/ a time formula

[Guest]

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

 

[Guest]

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

 

[Pete_UK]

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