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

Am Sat, 13 Aug 2011 08:33:31 +0100 schrieb Jake:

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...

Excel saves times as parts of day. 0,04... is 1 hour.
If difference less than 1 hour numberformat is [m], if it's more than 1
hour numberformat is h:mm
Have a look:
https://skydrive.live.com/view.aspx?...182 2A3%21194


Regards
Claus Busch

Learn something new every day - thanks!