Hi Greg

That worked ok for the example I gave, but when I use future dates that
are months away I do not get the result I would expext

eg

Future Date 09/09/2005 08:54
Now 30/06/2005 11:23

Result 10:21:03

The hours and minutes look ok but not the days??????


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=383463