Hello All
I would like to count down 48hrs from a supplied date and time. What I mean
is, when I start up my spreadsheet it will reference a cell in another
spreadsheet which is supplying a date and time (yyyy,mm,dd hh,mm) that is
not more than 48hrs old. I would like to display when 48hrs will expire from
that given time in a counting down (hh,mm) format.
Any assistance would be much appreciated,
Paul

If X is the supplied date and time, such that X < current time < (X + 2 days),
and you want to know the number of days, hours, and minutes between the
current time and X + 2 days,

=Sheet1!A1+2-NOW()

and format as dd hh:mm

BTW, does Excel recognize the time, X, as a time? If you've typed it in the
format you show below, it may not.

If I type this in a cell:

2004,10,20 22,03

it's text, not a date and time. If you need to convert from text, this formula
should do it

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+TIME(MID (A1,12,2),RIGHT(A1,2),0)


On Wed, 20 Oct 2004 22:47:55 -0400, "Paul" wrote:

Hello All
I would like to count down 48hrs from a supplied date and time. What I mean
is, when I start up my spreadsheet it will reference a cell in another
spreadsheet which is supplying a date and time (yyyy,mm,dd hh,mm) that is
not more than 48hrs old. I would like to display when 48hrs will expire from
that given time in a counting down (hh,mm) format.
Any assistance would be much appreciated,
Paul