I want to calculate the difference between todays date and dates in the
future in days, hours and minutes

eg Today 30/06/2005 10:37
Future date 03/07/2005 11:48

Difference 3 days 1 hour 11 minutes

What formula should I use and how should the cells be formatted?

Thanks for any help


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