Calculating time clock averages

  • Thread starter Thread starter big jim
  • Start date Start date
B

big jim

I need help with calculating time clock averages! Heres what I have:

Column A. row 1, has 2 min 46 sec
Column B, row 1, has 4 min 01 sec
Column C, row 1, has 4 min 10 sec
Column D, row 1, has 4 min 07 sec
Column E, row 1, shows the Average of Column A thru D

How do I format Column A thru D to show in time format and what should the
formula be in Column E to show the average of Column A thru D? What I have
in Column E shows an average of 3.66 but should be 4.06

Thanks in advance

Jim
 
Hi!

To enter a time in mm:ss format you still have to enter it
as h:mm:ss -

A1 - 0:2:46
B1 - 0:4:01
C1 - 0:4:10
D1 - 0:4:07

Excel stores times and dates as a decimal value. The
formatting is what makes it look like a time or date entry.

So, to average, it's simply:

=AVERAGE(A1:D1)

The correct answer is 0:3:46

If you got 3.66 you had to have entered the values as
decimal values.

2.46, 4.01, 4.10, 4.07

If you want to convert the time formatted values to
decimal value in minutes:

=AVERAGE(A1:D1)*1440 = 3.7666

1440 = TOTAL MINUTES IN 1 DAY

Format the cell as GENERAL

Biff
 
Back
Top