please help w/ a time formula

Z

Zb Kornecki

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
 
P

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
 
Top