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


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2