Averaging Time

B

BostonBoy

I’ve been asked to figure out how early an employee typically punches in for
work. They want to give her some sort of bonus. I have the punchclock data
in an excel column in the following format:

5/14/07 10:02 AM
5/15/07 9:16 AM
5/17/07 9:28 AM
5/18/07 9:16 AM
5/22/07 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.

Thanks!
 
M

Mike H

No need for a new thread, have a little patience. You have an answer in your
other thread and no doubt if others can see a better way you will get more.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging Time 1
Averaging Time 14
If Function 1
15 minute data to daily data 1
Count values from Pivot Table 11
Early Login, Last Logout 3
date/time calculation 3
SUMIF or COUNTIF 1

Top