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

Am Fri, 12 Aug 2011 20:58:00 +0200 schrieb Claus Busch:

if the times are less than 24 hours you don't need the date.
^^^^^^^^^^^
if the difference is less than 24 hours
You can calculate your difference with:
=MOD(F1-E1,1)

Regards
Claus Busch

Thanks Claus... that works.

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?