| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to specific "minutes:seconds" in cell format
I would like to record some sport reocrd which need input as
3:56 4:02 3:20 3:43..........something like that And I also need to use such data to draw the chart, but i got confuse how the excel know 3:56 which is closed 4:02. What kind of function or format I can use to do so? Please advise. Thanks all. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell such that "#NAME?" reads/appears "N/A"? | Excel Discussion (Misc queries) | |||
| Want to display degrees, minutes, seconds. (0°00'00") | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
Threaded Mode
