how to calculate average time

aymanharake · #1 02-16-2017, 12:16 PM

as the screenshot below shows, the average being calculated is wrong. why is this and how can i fix it?

Screen Shot 2017-02-16 at 19.14.52.png

I have made sure that all the cells are formated to time and not General

riothecat · #2 02-16-2017, 02:28 PM

can you post your worksheet?

jeffreybrown · #3 02-16-2017, 04:24 PM

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...

aymanharake · #4 02-16-2017, 04:51 PM

I am not sure what your question means, but here is my worksheet.

thanks

sleep.xlsx

jeffreybrown · #5 02-16-2017, 05:29 PM

In D2, try this formula instead...

=MOD(C2-B2,1)

...can copy down

aymanharake · #6 02-17-2017, 04:18 PM

Quote:

Originally Posted by jeffreybrown

In D2, try this formula instead...

=MOD(C2-B2,1)

...can copy down

That worked perfectly. thank you very much!

jeffreybrown · #7 02-17-2017, 04:22 PM

You are very welcome. Happy to help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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