On 10/4/08 10:16 AM, in article 59b5b46e.1@[EMAIL PROTECTED]
"gugapal@[EMAIL PROTECTED]
" <gugapal@[EMAIL PROTECTED]
> wrote:
> Hi Bob,
>
> First of all thanks a lot.
> I formatted future date (30.12.08 10:00) using dd.mm.aa hh:mm, I used
NOW()
> formatted the same way and then I asked Excel to subtract future date
from NOW
> and again used same format. I imagined I would get something counting
the
> minutes, hours and days, but the answer is a date. Can you help further?
Excel stores dates as sequential numbers, and time as the fractional part
of
that number. So, .5 is 12:00 noon. .25 is 6:00 AM, etc. The more decimal
digits the more detail to the time. So, when you subtract 2 times, the
integral part of the result is the number of days, and the fractional part
is the time difference. If you then format this as dd mm yy, you'll get a
new date offset from 1900 or 1904, depending on the date system you
selected. Depending on what you want to see in the result, you may need to
use another cell to display the answer. For example, if the result of the
subtraction is in A1, you might have another cell with this formula:
=Int(a1)&" Days "&text(A1, "hh:mm:ss")
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
|
