Calculate Days and Hours until a future day and time.

[Dan Mancuso]

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,

 

[Ron Rosenfeld]

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

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

 

[Dan Mancuso]

Thanks Ron,

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

Thanks again,

 

[Bob Phillips]

dd/mm/yyyy hh:mm:ss

--

HTH

RP

Thanks Ron,

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

Thanks again,

 

[Ron Rosenfeld]

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

 

[Dan Mancuso]

Thanks, that's it.

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

and format it as

m/d/yyyy h:mm am/pm


--ron

 

[Ron Rosenfeld]

Thanks, that's it.

You're welcome. Glad to help.


--ron