#1
|
|||
|
|||
how to calculate average time
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 |
#2
|
|||
|
|||
can you post your worksheet?
|
#3
|
|||
|
|||
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 As riothecat says, if this does not help a workbook could solve any guessing... |
#4
|
|||
|
|||
|
#5
|
|||
|
|||
In D2, try this formula instead...
=MOD(C2-B2,1) ...can copy down |
#6
|
|||
|
|||
That worked perfectly. thank you very much!
|
#7
|
|||
|
|||
You are very welcome. Happy to help.
|
Thread Tools | |
Display Modes | |
|
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 |