Comparing 2 dates and times

Hi

I have a spreadsheet with 5 columns:

A = date an e-mail received
B = time e-mail received on that date
C = date e-mail replied to
D = time e-mail replaied to on that date e-mail
E = was the e-mail replied to within agreed time limit?

The agreed time limit is 24 hours.

I'd be happy enough coming up with a formula to input Y or N into colmun E,
if I only knew how to subract a time AND date from another time and date.

Can anyone advise, please?

Many thanks.

Keith

David
Thu May 08 09:34:55 CDT 2008

=IF((C1+D1)-(A1+B1)<=1,"Y","N")
--
David Biddulph

"bollard" <bollard@discussions.microsoft.com> wrote in message
news:B90C430B-8B99-46D0-8064-01FB684A1EAB@microsoft.com...
> Hi
>
> I have a spreadsheet with 5 columns:
>
> A = date an e-mail received
> B = time e-mail received on that date
> C = date e-mail replied to
> D = time e-mail replaied to on that date e-mail
> E = was the e-mail replied to within agreed time limit?
>
> The agreed time limit is 24 hours.
>
> I'd be happy enough coming up with a formula to input Y or N into colmun
> E,
> if I only knew how to subract a time AND date from another time and date.
>
> Can anyone advise, please?
>
> Many thanks.
>
> Keith
>
>

bollard
Thu May 08 10:13:01 CDT 2008

Hi David

Many thanks for this, but can you tell me what format the respective columns
need to be in so that this formaula will work?

Cheers.

Keith

"David Biddulph" wrote:

> =IF((C1+D1)-(A1+B1)<=1,"Y","N")
> --
> David Biddulph
>
> "bollard" <bollard@discussions.microsoft.com> wrote in message
> news:B90C430B-8B99-46D0-8064-01FB684A1EAB@microsoft.com...
> > Hi
> >
> > I have a spreadsheet with 5 columns:
> >
> > A = date an e-mail received
> > B = time e-mail received on that date
> > C = date e-mail replied to
> > D = time e-mail replaied to on that date e-mail
> > E = was the e-mail replied to within agreed time limit?
> >
> > The agreed time limit is 24 hours.
> >
> > I'd be happy enough coming up with a formula to input Y or N into colmun
> > E,
> > if I only knew how to subract a time AND date from another time and date.
> >
> > Can anyone advise, please?
> >
> > Many thanks.
> >
> > Keith
> >
> >
>
>
>

David
Thu May 08 11:12:19 CDT 2008

Any Excel date or time format. Not text.
--
David Biddulph

"bollard" <bollard@discussions.microsoft.com> wrote in message
news:2917A627-93AB-48C5-A277-117A3644E858@microsoft.com...
> Hi David
>
> Many thanks for this, but can you tell me what format the respective
> columns
> need to be in so that this formaula will work?
>
> Cheers.
>
> Keith
>
> "David Biddulph" wrote:
>
>> =IF((C1+D1)-(A1+B1)<=1,"Y","N")
>> --
>> David Biddulph
>>
>> "bollard" <bollard@discussions.microsoft.com> wrote in message
>> news:B90C430B-8B99-46D0-8064-01FB684A1EAB@microsoft.com...
>> > Hi
>> >
>> > I have a spreadsheet with 5 columns:
>> >
>> > A = date an e-mail received
>> > B = time e-mail received on that date
>> > C = date e-mail replied to
>> > D = time e-mail replaied to on that date e-mail
>> > E = was the e-mail replied to within agreed time limit?
>> >
>> > The agreed time limit is 24 hours.
>> >
>> > I'd be happy enough coming up with a formula to input Y or N into
>> > colmun
>> > E,
>> > if I only knew how to subract a time AND date from another time and
>> > date.
>> >
>> > Can anyone advise, please?
>> >
>> > Many thanks.
>> >
>> > Keith
>> >
>> >
>>
>>
>>