Thread: Need help with averaging a time but dates are messing up the result I am trying for.
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chadsxe
 
Posts: n/a
Default Need help with averaging a time but dates are messing up the result I am trying for.

No luck...

That does pretty much the same thing as the other formula. I am
starting to think this is not possible. How do you take

06/12/06 11:55 Pm
06/19/06 12:55 Am

Average the two times not based on the dates but based on the fact that
one is in the morning of a diffrent day. Hmmm....I Don't know


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

Reply With QuoteReply With Quote