| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging times (similar to lap times)
Hello, I have some dates like this:
1:54.334 1:54.442 1:54.553 I want to average the three, and then work out the difference with another three. The big problem seems to be the rounding. When I change the cells to time format, they just go to 00:01:55. (or :54). Not really what I want. What is the best way to do this? It is excel 2003. Cheers |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Averaging times (similar to lap times)
format cells as:
mm:ss.000 "cqmman" wrote: Hello, I have some dates like this: 1:54.334 1:54.442 1:54.553 I want to average the three, and then work out the difference with another three. The big problem seems to be the rounding. When I change the cells to time format, they just go to 00:01:55. (or :54). Not really what I want. What is the best way to do this? It is excel 2003. Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| averaging times | Excel Worksheet Functions | |||
| Averaging Values between Two Dates/Times | New Users to Excel | |||
| Averaging Values between Two Dates/Times | Excel Worksheet Functions | |||
| Averaging Times w/ AM PM | Excel Discussion (Misc queries) | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
Linear Mode
