View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Formatting time for m:ss.00

Hi John,

I don't know why you are having problems. Formatting as Time then Custom you
can format as m:ss.00

--
Regards,

OssieMac


"John Boulton" wrote:

I would like to be able to format columns/cells to read time inthe format
m:ss.00 or alternatively m:ss:00 (for determining beaten margins of
racehorses the finishing times are given in the above formats but excel
doesn't appear to want to mix or match them
any assistance would be appreciated
JB