Didn't work for me. The formula seems affested by the empty cells in between
the numbers. Any ideas?

"David Biddulph" wrote:

Not a problem if there are empty rows. The formula still works.
--
David Biddulph

"BostonBoy" wrote in message
...
Any way to make that formula work with empty rows in between the entries?
I've got a couple hundred of them.

"Glenn" wrote:
With your data in A1:A5, put the following in B1:

=AVERAGE(MOD(A1:A5,1))

and hit Ctrl-Shift-Enter (because this is an array formula).

Format B1 as time.

BostonBoy wrote:
We're trying to figure our how early an employee typically punches in
for
work, as we want to give her a bonus. I have the punch clock data in
an
excel column in the following format (a few of the entries from this
past
month):

5/14/08 10:02 AM
5/15/08 9:16 AM
5/17/08 9:28 AM
5/18/08 9:16 AM
5/22/08 9:15 AM

She's supposed to start work at 10:00am every day, and I need to figure
out
what time she usually checks in. I've tried a typical averaging
formula, but
that gives me the mean time between all of the days, which is around
noon on
the 17th.

Any ideas?

Sorry if this is a duplicate post by me in the last couple of minutes.
I've
been having trouble with the log-on for the last hour.