Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel how do I format swimming times - mm.ss.100ths
MIN should work.
time is stored as a fraction of a 24 hour day, so regardless of what time you are storing, it should work. format the cell with the MIN formula using a custom number format like mm:ss.0 -- Regards, Tom Ogilvy "Vistadelmare" wrote in message ... I want to make a record of swimming times for swimmers in the Club. I need to calculate the P.B. (minimum time out of those listed) and I assume I use the =MIN(-,-) formula. BUT it doesn't appear to work because I can't get the format to be understood as minutes, seconds and 100ths of seconds. Alternatively, does anyone have a setup they are prepared to share with me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to work out 15% of swimming times in minutes seconds and 100t. | Excel Discussion (Misc queries) | |||
How can I count min bt 100ths | Excel Discussion (Misc queries) | |||
Excel should be able to format 12-hour times without am/pm | Excel Discussion (Misc queries) | |||
How to format elapsed time for swimming scores | Charts and Charting in Excel | |||
In Excel how do I format swimming times - mm.ss.100ths | Excel Programming |