Paul,
Is this any good?
=(INT(A1-TODAY())-(MOD(A1,1)-MOD(NOW(),1)<0))&" days
"&TEXT(MOD(A1-NOW(),1),"hh:mm:ss")
--
HTH
Bob Phillips
"Paul Sheppard"
wrote in message
news:Paul.Sheppard.1rfp2h_1120125917.5871@excelfor um-nospam.com...
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