how to calculate average time

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:18 PM.