| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lap Times
Hi. I am trying to create an info chart for a car club, but i cannot get
excel to handle lap times properly. What i need is to be able to enter say, 1'34.779 and be able to manipulate it as a time rather then a general number. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lap Times
use the custom format for your cells of mm:ss.000
this will display minutes seconds and thousands to 3 decimal places. Note I've used the colon delimeter so time should be entered as 1:34.779 Mike "NightmareBlade" wrote: Hi. I am trying to create an info chart for a car club, but i cannot get excel to handle lap times properly. What i need is to be able to enter say, 1'34.779 and be able to manipulate it as a time rather then a general number. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lap Times
Put it in as 1:34.779
-- David Biddulph "NightmareBlade" wrote in message ... Hi. I am trying to create an info chart for a car club, but i cannot get excel to handle lap times properly. What i need is to be able to enter say, 1'34.779 and be able to manipulate it as a time rather then a general number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding up times from a Triathalon | Excel Discussion (Misc queries) | |||
| Count the number of times a cell value is within a specific range | Excel Worksheet Functions | |||
| Avg Times in MOD fx using selected rows | Excel Worksheet Functions | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
| SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
Linear Mode
