Thread: Timetable
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jake[_6_] Jake[_6_] is offline
external usenet poster
 
Posts: 17
Default Timetable


"Claus Busch" wrote in message
...
Hi Jake,

Am Fri, 12 Aug 2011 22:20:41 +0100 schrieb Jake:

I also have a column for duration of stop which is the difference between
the arrival time and departure time. At the moment it shows 00:xx as the
train never stops for a duration greater than an hour. Any way to remove
these superfluous 00 and just have the minutes formatted as a number (xx)
instead?


custom number format:
[<0,041]mm;hh:mm


Thanks again, but that doesn't seem to work, can I ask what all that stuff
does? I played around a bit and found a custom number format of [m] works...