Calculating differences in dates

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

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,

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" <Paul.Sheppard.1rfp2h_1120125917.5871@excelforum-nospam.com>
wrote in message
news:Paul.Sheppard.1rfp2h_1120125917.5871@excelforum-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
>

Bob

Thanks, that works fine

Paul

That is because the dd will only go up to 31, then it cycles back to 1. Been
caught by that myself <vbg>

--
HTH

Bob Phillips

"Paul Sheppard" <Paul.Sheppard.1rfruc_1120129521.3682@excelforum-nospam.com>
wrote in message
news:Paul.Sheppard.1rfruc_1120129521.3682@excelforum-nospam.com...
>
> 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
>