Bernie Deitrick Wrote:
Chad,

Array enter (enter using Ctrl-Shift-Enter)

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

Note that the average isn't around midnight, since times are from 0 -
Midnight to .5 Noon to 1 the
next Midnight

HTH,
Bernie
MS Excel MVP


I don't mean to sound stupid and bug you but that went way over my
head. Can you please try and explain it in a diffrent way.

Thanks

Chad


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