=TEXT(AVERAGE(IF(TIME(LEFT(A2:A9,2),RIGHT(A2:A9,2) ,0)0.5,TIME(LEFT(A2:A9,2),RIGHT(A2:A9,2),0),TIME( LEFT(A2:A9,2),RIGHT(A2:A9,2),0)+1)),"hhmm")
should work entered as an array shift ctrl enter
I tested it based on your spreadsheet link and it worked
I have said that if the finish time is after midday (0.5) it is a
finish, if it is before midday then it is the next day, if this is the
case i have added 1 to the value. I think this is what you want as an
average
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=572543