BostonBoy wrote:
Were 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

Shes supposed to start work at 10:00am every day, and I need to figure out
what time she usually checks in. Ive 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.


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.