So how are you defining your "average"?
What is the "average" of 11:00 and 23:00?
What is the "average" of 12:00 and 23:00?
What is the "average" of 10:00 and 23:00?

Tell us what algorithm you want to use, and we can then hopefully show you
how to do it in Excel.
Before what time do you want a time to be treated as if it were the end of
the previous day rather than the start of that day?
--
David Biddulph

"WOLLAM" wrote in message
...
Thank you in advance for all the help.
I have read the recent posts about averaging time, but none fit my
question.
I am trying to average a set of times that are on both sides of
12midnight.
All of the formulas I have been attempting are averaging the times as if
they
are times of day that are several hours apart; when in fact they are just
a
couple of hours apart. The times for my example a
12:45 am
11:01 pm
2:05 am
The average of these times should be 12:37 am. 'Simple' average formula
results in 8:37 am. I have toyed with some of the other formulas
mentioned
in the others posts, but to no avail. Thanks again for all the help.
Dan