Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Time withing Excel
What formula are you using to do the averaging?
Are you sure your cells have valid Excel times in them, or do they have text masquerading as times? -- Regards, Fred "RamblingWreckGT" wrote in message ... I have a column of data that is mm:ss . I am wishing to have Excel Average the times. I have had no suceess by formating the column as mm:ss and then performing the function. I countunualy get the result of #DIV/0!. Note: I am using Office 2000 Help!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Time withing Excel
the data in the cell is, for example, 10:23
and the average funchtion I am using is =AVERAGE() "Fred Smith" wrote: What formula are you using to do the averaging? Are you sure your cells have valid Excel times in them, or do they have text masquerading as times? -- Regards, Fred "RamblingWreckGT" wrote in message ... I have a column of data that is mm:ss . I am wishing to have Excel Average the times. I have had no suceess by formating the column as mm:ss and then performing the function. I countunualy get the result of #DIV/0!. Note: I am using Office 2000 Help!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Time withing Excel
"RamblingWreckGT" wrote in
message ... "Fred Smith" wrote: What formula are you using to do the averaging? Are you sure your cells have valid Excel times in them, or do they have text masquerading as times? the data in the cell is, for example, 10:23 and the average funchtion I am using is =AVERAGE() The question Fred asked was: "Are you sure your cells have valid Excel times in them, or do they have text masquerading as times?" Have you looked at the format of the cells in question? Have you tried =ISTEXT(A1) or =ISNUMBER(A1)? If you've got text, change the format of the cells to time, then put a zero in a spare cell, copy that cell, select the cells you want changing to time, then paste special/ add. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Tracking in Excel | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Determining current Time Zone In Excel | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |