| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to format elapsed time for swimming scores
I'm trying to graph times for my son's swimmin team for each person
by event and by date so we can show progress over time. When I use the time fomat I end up with an AM or PM after the time. I don't want this - only elapsed time. Thanks |
|
#2
|
|||
|
|||
|
T-mo,
Instead of the formats within the Time option, try using the Custom option. In the Format Axis dialog box - Number tab, select the Custom option. Either select or type into the "Type" input area: mm:ss ---- Regards, John Mansfield http://www.pdbook.com "T-mo" wrote: I'm trying to graph times for my son's swimmin team for each person by event and by date so we can show progress over time. When I use the time fomat I end up with an AM or PM after the time. I don't want this - only elapsed time. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
| I cannot get time format to display in a drop-down list | Excel Discussion (Misc queries) | |||
| elapsed time calculation | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
Linear Mode
