|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 8th, 2002, 10:43 PM
|
#1 |
|
New Member
Join Date: May 2002
Posts: 2
|
I have a list of times (eg 1.05:30) and i need to find the average, when i use the normal average function i only get zero (0:00:00). can someone please help me out?!
|
|
|
|
May 8th, 2002, 10:56 PM
|
#2 | |
|
MrExcel MVP
Join Date: Mar 2002
Location: Michigan USA
Posts: 11,452
|
Quote:
=AVERAGE(A:A) Hope This Helps!
__________________
Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com |
|
|
|
|
|
May 8th, 2002, 11:27 PM
|
#3 |
|
New Member
Join Date: May 2002
Posts: 2
|
I tried that and it still doesn't work!
my values are in the format - min:sec:milisec and when i try that i get #DIV/0... is there anything else u think i could try?! |
|
|
|
|
May 9th, 2002, 03:22 AM
|
#4 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Newcastle, UK
Posts: 1,174
|
Quote:
is this the way the times are entered, try changing the 1.05:30 to 1:05:30.
__________________
"Have a good time......all the time" Ian Mac |
|
|
|
|
|
May 9th, 2002, 04:48 AM
|
#5 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Newcastle, UK
Posts: 1,174
|
Quote:
is this the way the times are entered, try changing the 1.05:30 to 1:05:30.
__________________
"Have a good time......all the time" Ian Mac |
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
