how to calculate average time

		Microsoft Office Forums > Microsoft Excel > Excel
how to calculate average time

FAQ

Thread Tools

Display Modes

02-16-2017, 04:24 PM

jeffreybrown jeffreybrown is offline

Windows Vista how to calculate average time

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Are you sure your times are numbers?

Here's what I get...

Code:

      ----C----- ---D---- ---E---
  1   wake up at   time   Average
  2    5:00:00   8:00:00  7:00:00
  3    9:00:00   10:00:00        
  4    8:00:00   3:00:00

E2 =AVERAGE(D2 : D4)

As riothecat says, if this does not help a workbook could solve any guessing...

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to calculate weighted average in table?	alexsimpson	Word Tables	3	12-01-2016 03:19 PM
dynamic ranges to calculate average	teatree	Excel	1	11-11-2016 10:11 AM
dynamic ranges to calculate average	teatree	Excel	1	11-11-2016 10:03 AM
Calculate average age	FTL	Excel	1	08-09-2016 06:56 AM
Calculate Average Time Elapsed in Days, hours and minutes	Nina46	Excel	9	09-11-2015 02:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:17 PM.