| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Time Format
Hi All, I am having diificulty reading a columb of data reading different lenghts of time in this format 00:25:06 and 00:42:46 etc I am looking to find the average but have no luck as i have imported the data. please help thanks Brento -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=526896 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Average Time Format
Just use
=AVERAGE(A:A) and format as time also -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Brento" wrote in message ... Hi All, I am having diificulty reading a columb of data reading different lenghts of time in this format 00:25:06 and 00:42:46 etc I am looking to find the average but have no luck as i have imported the data. please help thanks Brento -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=526896 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Average Time Format
Times is just numbers and can be averages as such, what's the problem you
are having? If it is that the import is text, format and empty cell to time format, copy it, select the import and do editpaste special and select add -- Regards, Peo Sjoblom "Brento" wrote in message ... Hi All, I am having diificulty reading a columb of data reading different lenghts of time in this format 00:25:06 and 00:42:46 etc I am looking to find the average but have no luck as i have imported the data. please help thanks Brento -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=526896 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 24 time format and calculations | Excel Worksheet Functions | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| Insert spinning button with time format in Excel 2000? | Excel Discussion (Misc queries) | |||
| elapsed time average calculcations | Excel Discussion (Misc queries) | |||
| time format | Excel Worksheet Functions | |||
Linear Mode
