Perhaps just a straight average:

=AVERAGE(A1:E1)-INT(AVERAGE(A1:E1))

formatted as time...

HTH,
Bernie
MS Excel MVP


"chadsxe" wrote in message
...

O.k. that makes sense and I have tested it out but there is still that
one flaw. Say for example

A1 = 11:30PM (driver come in at 11:30 at night)
A2 = 12:00AM (driver comes in a half hour later at 12:00 in the
morning)

The formula you suggested looks at this and says this is on the same
day. But in reality it is not no the same dam and the average between
the 2 should be 11:45PM. The formula you suggested works fine if the
drivers come in on the same day. But as soon as some one comes in past
the Mid-night mark it then throughs that time back into the same 24 hour
block as the rest of them. Did that make sense?


--
chadsxe
------------------------------------------------------------------------
chadsxe's Profile: http://www.excelforum.com/member.php...o&userid=35421
View this thread: http://www.excelforum.com/showthread...hreadid=552284