Calculate Days and Hours until a future day and time.

How do I calculate the difference between the current date and time and a
future date and time. I want the sheet to insert the current date and time
(which I am able to do) and calculate the number of days, hours and minutes
until a fixed date and time in the future.

I can't separate the current time from the NOW() function.

Thanks,

On Sat, 2 Oct 2004 11:35:03 -0700, "Dan Mancuso" Dan
wrote:

How do I calculate the difference between the current date and time and a
future date and time. I want the sheet to insert the current date and time
(which I am able to do) and calculate the number of days, hours and minutes
until a fixed date and time in the future.

I can't separate the current time from the NOW() function.

Thanks,

=INT(A1-NOW())&" days "&TEXT(MOD(A1-NOW(),1),"h"" hrs ""m"" mins""")


--ron

Thanks Ron,

How do I format the future date in A! with the time of the event on that day?

Thanks again,

"Ron Rosenfeld" wrote:

On Sat, 2 Oct 2004 11:35:03 -0700, "Dan Mancuso" Dan
wrote:

How do I calculate the difference between the current date and time and a
future date and time. I want the sheet to insert the current date and time
(which I am able to do) and calculate the number of days, hours and minutes
until a fixed date and time in the future.

I can't separate the current time from the NOW() function.

Thanks,

=INT(A1-NOW())&" days "&TEXT(MOD(A1-NOW(),1),"h"" hrs ""m"" mins""")


--ron

dd/mm/yyyy hh:mm:ss

--

HTH

RP

"Dan Mancuso" wrote in message
...
Thanks Ron,

How do I format the future date in A! with the time of the event on that
day?

Thanks again,

"Ron Rosenfeld" wrote:

On Sat, 2 Oct 2004 11:35:03 -0700, "Dan Mancuso" Dan
wrote:

How do I calculate the difference between the current date and time and
a
future date and time. I want the sheet to insert the current date and
time
(which I am able to do) and calculate the number of days, hours and
minutes
until a fixed date and time in the future.

I can't separate the current time from the NOW() function.

Thanks,

=INT(A1-NOW())&" days "&TEXT(MOD(A1-NOW(),1),"h"" hrs ""m"" mins""")


--ron

On Sat, 2 Oct 2004 14:49:10 -0700, "Dan Mancuso"
wrote:

Thanks Ron,

How do I format the future date in A! with the time of the event on that day?

Thanks again,


Enter it as, for example, 5/25/05 8:15 A

and format it as

m/d/yyyy h:mm am/pm


--ron

Thanks, that's it.

"Ron Rosenfeld" wrote:

On Sat, 2 Oct 2004 14:49:10 -0700, "Dan Mancuso"
wrote:

Thanks Ron,

How do I format the future date in A! with the time of the event on that day?

Thanks again,


Enter it as, for example, 5/25/05 8:15 A

and format it as

m/d/yyyy h:mm am/pm


--ron

On Sat, 2 Oct 2004 17:43:04 -0700, "Dan Mancuso"
wrote:

Thanks, that's it.


You're welcome. Glad to help.


--ron